How to get array via hasMany relationship?

Question

Yii

There are 3 tables users, companies, user role in the company, companies
Accordingly, there are connections:
users->hasMany user role in the company
user role in the company -> hasOne company
It is necessary to select companies for a specific user.
I can't figure out how to do it right.

Answer 1

And the casket just opened

$array = $this->hasMany(Имя первой связиe::className(), ['user_id' => 'id'])->all();
        return ArrayHelper::getColumn($array,'имя второй связи');

Still, beer sometimes helps.

Answer 2

MANY TO MANY, the viaTable method will help you.