controller

publicfunctionactionIndex(){$myUser=newMyUser();$myuserQuery=$myUser::find()->select(['fuid','fusername','femail','fstatus','fname'])->join('LEFTJOIN','wanguan_roles','wanguan_admin.frule=wanguan_roles.fid');$listDataProvider=newActiveDataProvider(['query'=>$myuserQuery,'pagination'=>['pageSize'=>50,],]);return$this->render('list',['listDataProvider'=>$listDataProvider]);}

view

<?phpechoGridView::widget(['summary'=>false,'dataProvider'=>$listDataProvider,'pager'=>['firstPageLabel'=>'首页','lastPageLabel'=>'尾页','nextPageLabel'=>'下一页','prevPageLabel'=>'上一页','maxButtonCount'=>6,],'columns'=>[['attribute'=>'fusername','label'=>'用户名',],['attribute'=>'femail','label'=>'邮箱'],['attribute'=>'fstatus','label'=>'状态','format'=>'raw','value'=>function($model){return$model['fstatus']==1?Html::tag('span','有效',['class'=>'labellabel-success','id'=>$model['fuid'],'data'=>['id'=>$model['fuid']]]):Html::tag('span','无效',['class'=>'labellabel-default','id'=>$model['fuid'],'data'=>['id'=>$model['fuid']]]);}],['attribute'=>'fname','label'=>'角色','value'=>function($model){returnisset($model->fname)?$model->fname:'';}]]]);?>