我已经用yii2db查询解决了这个问题。

$subquery = Adanalytics::find()->
            select('id,ad_id,date_event,max(cpc) cpclick,max(cpv) cpview,max(impression) impression,max(view) view,max(clicks) clicks,visitor_ip,publisher_id')->
            from('ad_analytics')->
            where(['publisher_id' =>  Yii::$app->user->identity->id ])->
            groupBy('ad_id,date_event,visitor_ip');
  $query=Adanalytics::find()->
        select('ad_id,date_event,sum(cpclick) total_click_cost,sum(cpview) total_view_cost,sum(impression) total_impression,sum(view) total_views,sum(clicks) total_clicks,publisher_id')->
        from(['t'=>$subquery])->
        groupBy('t.ad_id,t.date_event');

并在网格视图中调用列。

'columns' => [
        ['class' => 'yii\grid\SerialColumn'],
        'ad_id',
        'total_impression',
        'total_views',
        'total_clicks',
        'total_click_cost',
        'total_view_cost',
        'date_event',

        ['class' => 'yii\grid\ActionColumn'],
    ],

在调用之前在模型中定义它们。

public $total_click_cost;
   public $total_view_cost;
   public $total_impression;
   public $total_views;
   public $total_clicks;

如果只需要该列作为gridview中的显示值，则可以创建计算列。

'cpview',
[
    'label' => 'Totalcost',
    'value' => function($model){
        return $model->cpclick * $model->clicks;
    }
],

或者你可以在adanalytics类的开始添加

public $totalccost;

如果您想在任何地方使用计算，您可以执行以下操作。在您的模型中

public function getTotalcost() 
{
   return $this->clicks * $this->cpclick; 
}

你可以给这个属性添加标签

public function attributeLabels()
{
    return [
        ...
        'totalcost' => Yii::t('app', 'Total cost'),
    ];
}

在网格视图列中

...
'cpview',
'totalcost'

您可以在任何地方使用此函数作为$model->totalcost