select(); foreach ($class as $val){ $plug = M('plug as p') ->join('ls_plug_agent as pa on pa.plug_id=p.id AND pa.agent_id='.$user['id'],'LEFT') ->where(array('p.class_id'=>$val['id'])) ->field('p.*,pa.a_status') ->select(); $temp = array(); $temp['class_id'] = $val['id']; $temp['class_name'] = $val['class_name']; $temp['list'] = $plug?$plug:array(); $list[] = $temp; unset($temp); unset($plug); } $this->assign('list',$list); $this->display(); } }