How to select the desired column from a related table in AR Yii2?

Question

Yii

$arr = Menu::find()->with([
                'link' => function ($query) {
                    $query->select('menu_id, role_id');
                }
            ])->asArray()->all();

This is the link code in the model:

public function getLink()
    {
        return $this->hasMany(Menu_role::className(), ['menu_id' => 'id']);
    }

The problem with this example is that such a method obliges you to select the key by which the link was made (here it is menu_id).
That is, you don’t seem to get conditionally all 6 columns of the table, but you should always get the key, such a half-measure.

Maybe there is some other way to select in this case, or can this code be modified somehow?

Answer 1

$arr = Menu::find()
    ->with(['link'])
    ->select(['menu_role.menu_id', 'menu_role.role_id'])
    ->asArray()
    ->all();