alias('a') ->join(['auth_group'=>'g'],'a.group_id = g.id') ->field('g.name,g.id') ->find(); if($name){ return $name; } return false; } }