//controller
public function actionReport()
    {
        $searchModel = new AssetReceivedSearch();
        $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
	//tambah ini aja ini pakai DAO
$posts = Yii::$app->db->createCommand('SELECT a.id_asset_master,b.asset_name,a.received_year, Count(*) as num FROM asset_received  a
Inner Join asset_master b on b.id = a.id_asset_master
GROUP BY received_year, id_asset_master')
    ->queryAll();
 //pakai Query Builder
/* $posts = (new Query())
->select(["id_asset_master,received_year, Count(*) as num"])
->from("asset_received")
->groupBy("received_year, id_asset_master")->all();
 */

        return $this->render('report', [
            'searchModel' => $searchModel,
            'dataProvider' => $dataProvider,
'post'=>$post
        ]);
    }

//view
 <?= \kartik\grid\GridView::widget([
            'dataProvider' => $dataProvider,
'columns'=>[
'id',
'asset_name','received_year','num '
]
?>