How to display data linked through an intermediate table in a gridview?

Question

Yii

I display a list of users using gridview. But I would also like to add belonging to the role (each user has one role). It can be displayed through the item_name link, but I want to display a full-fledged record, description. How can this be implemented

Answer 1

[
  'label' => 'Роль',
  'value' => function($model){
    return $model->authAssignment->authItem->description;
  }
]

Just make sure the link chain exists and add eager loading to UserSearch:

$query = User::find()->with([
  'authAssignment' => function($q){
    return $q->with('authItem');
  }
]);