GridView多表關聯

有些時候，需要多表關聯查詢，使用SqlDataProvider比較靈活

Controller中

$dataProvider = new SqlDataProvider([ 
    'sql' =>$sql, 
    'totalCount' => $totalCount, 
    'pagination' => [ 
        'pageSize' => 10, 
    ], 
]);       

$gridcolumn[0]=['class'=>'kartik\grid\SerialColumn'];
$gridcolumn[1]=['label'=>'AA','value'=>"name"];
//省略      

<?= GridView::widget([ 
       'dataProvider' => $dataProvider, 
       'columns' =>$gridcolumn,
　　　　
   ]); ?>