How to link 3 yii2 tables?

Question

Yii

There are 3 tables, you need to connect them, as I understand it, they need to be connected with the 4th table

. But I can’t figure out how to do this in terms of code. I registered everything in the tables, I generated the model for the 4th table through gii, but I don’t understand further ((

public function getBooks()
{
    return $this->hasOne(Books::className(), ['id' => 'books_id']);
}

public function getReview()
{
    return $this->hasOne(Reviews::className(), ['id' => 'review_id']);
}

public function getUser()
{
    return $this->hasOne(User::className(), ['id' => 'user_id']);
}

I need all this to display normally Reviews in certain books and display Nicky, those who wrote.
If there is another option for linking tables, I will not mind redoing everything)))

Answer 1

If you do not want to store identifiers in the tables themselves, then you need to use intermediate tables , in your mind you should have a separate table for each connection then.