1.两个表查询
field('projectno')->where(array('id'=>$userid))->select();
$xq = M('project');
$datas = $xq->field('name')->where(array('id'=>$data[0][projectno]))->select();
$this->assign('xq',$datas);
$this->assign('title',$datas[0][name].'物业系统');
join('INNER JOIN pro_project ON pro_cuser.projectno = pro_project.id')->where(array('pro_cuser.id'=>$userid))->select();
$this->assign('xq',$data);
$this->assign('title',$data[0][name].'物业系统');
原文链接：https://www.f2er.com/thinkphp/67923.html