Код: Выделить всё
public function actionPhotographers()
{
$dataProvider = new ActiveDataProvider([
'query' => User::find()->select(['user.id', 'username', 'COUNT(photo.id) AS count'])->joinWith('photos', true, 'INNER JOIN')->orderBy('count DESC')->groupBy('username'),
'pagination' => [
'pageSize' => 20,
'pageSizeParam' => false
],
]);
return $this->render('photographers', [
'dataProvider' => $dataProvider,
]);
}