Thinkphp多表联查mysql写法

$model=M("user","","mysql://root:222222@localhost:3306/jiaoyou"); //换数据库
原生写法：
//$sql="select a.areaname,u.userid,u.username , u.gender, u.avatar, u.avatarflag ,p.cityid,p.height,p.astro ,p.ageyear ,
p.marrystatus ,p.lunar, p.education from user u , user_profile p,area a where  p.cityid='53' 
and  a.areaid=p.cityid and u.userid=p.userid  and p.lunar >'0' and p.astro >'0' and u.avatarflag=1 order rand() limit 14";

Tp 写法：   主要是table用法            

$dataList=$model->field($condition['field'])->table(array('user'=>'u' , 'user_profile'=>'p','area'=> 'a' ,
'user_params'=>'ps'))->where("ps.elite>'0' and   p.cityid='$branch_id' and  a.areaid=p.cityid and u.userid=p.userid  
and p.lunar >'0' and p.astro >'0' and u.avatarflag=1")->limit($condition['limit'])->select();

 

转载于:https://www.cnblogs.com/hnbiao/p/4588944.html