How to correctly form a SQL query in Yii2?

Question

Yii

I have three tables: book(id, title, author) and category(id, title) linked by table book_category(id, book_id, category_id). How can I make the correct andWhere so that books are displayed where category = $search_cat?

$books = Book::find()->orderBy('id DESC')
                    ->andWhere(['like', 'title', $search_title])
                    ->andWhere(['like', 'author', $search_author])
                    ->andWhere(['like', 'category', $search_cat]);

Relationships are configured as follows:
In the Book model:

public function getBookCategory()
    {
        return $this->hasMany(BookCategory::className(), ['book_id' => 'id']);
    }

    public function getCategories(){
        return $this -> hasMany(Category::className(), ['id' => 'category_id']) -> via('bookCategory');
    }

In the Category model:

public function getBookCategory()
    {
        return $this->hasMany(BookCategory::className(), ['category_id' => 'id']);
    }

In the BookCategory model:

public function getCategory()
    {
        return $this->hasOne(Category::className(), ['id' => 'category_id']);
    }

    public function getBook()
    {
        return $this->hasOne(Book::className(), ['id' => 'book_id']);
    }

Answer 1

Please recommend books for learning C++

Qt

Answer 2

in general, you can create beautiful applications using C ++, or is there no way without C #?

No, just scary. Probably you will have to choose another language.

Answer 3

) And in general, you can create beautiful applications using C ++, or is there no way without C #?

Yes, you can, you can create the coolest applications on winApi ;)

Answer 4

And I thought that beautiful applications can only be written in JavaScript, but they are written on what. Oh well, I still write ugly programs in this terrible C and ancient assembler