Код: Выделить всё
+--------+----------+
| Users | Comments |
+--------+----------+
| id | id |
| status | user_id |
| name | text |
+--------+----------+
Код: Выделить всё
return new ActiveDataProvider([
'query' => User::find()->andWhere(['status' => User::STATUS_ACTIVE])
->joinWith('comments')
->orderBy(['COUNT(comments.id)' => SORT_DESC])
]);