Yii2 sum with group by in gridview not working

Question

以下是我的查询：

$query = AssignApplicant::find()
                ->select(['sum(total_pay) as sum','applicant.first_name','applicant.last_name'])
                ->joinWith(['position', 'applicant'])->orderBy(['job_positions.id' => SORT_DESC]);
 $query->groupBy(['applicant_id']);

我的网格视图

GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'kartikgridSerialColumn'],
            [
                'attribute' => 'applicant',
                'value' => 'applicant.first_name',
            ],
            'sum'
        ],
    ]);

此print null for pherceant.first_name。当我在DB中运行RAW查询时，它可以正常工作。当我删除以下行时，它显示了第一个_NAME，但没有显示总和

->select(['sum(total_pay) as sum','applicant.first_name','applicant.last_name'])

Answer 1

i通过更改以下方式解决：

 ->select(['sum(total_pay) as sum','`assign_applicant`.*'])