Question

请教各位大神tp5怎么进行多表查询

Answer 1

$data=$user->alias('u')
            ->join('(select a.*,sum(money) summoney from (select * from client_consumption ORDER BY jz_time desc) a group by a.uid ) con','con.uid=u.id')
            ->join('province p','p.province_id=u.province_id','LEFT')
            ->join('city c','c.city_id=u.city_id','LEFT')
            ->join('county co','co.county_id=u.county_id','LEFT')
            ->join('dev_from d','d.id=u.dev_id','LEFT')
            ->join('source s','s.id=u.from_id','LEFT')
            ->join('zx_tools z','z.id=u.tool_id','LEFT')
            ->join('wangdian_zixun w','w.id=wdzx_id','LEFT')
            ->join('qiantai_zixun q','q.id=qtzx_id','LEFT')
            ->join('doctors doc','doc.id=doctor_id','LEFT')
            ->join('disease dis','dis.id=disease_id','LEFT')
            ->field('u.id,u.name,u.sex,u.birthday,u.age,u.telephone,p.province_name,c.city_name,co.county_name,d.dev,source_name,z.tool,wd_name wdname,qt_name qtname,doc.doctor,disease_name,jz_time,summoney,addtime')
            // ->group('u.id')
            ->where('name|telephone','like',"%$name%")
            ->where('summoney',['>',$startmoney],['<',$endmoney],'and')
            ->order([$sort=>$order])
            ->limit($offset,$rows)
            ->select(false);
            dump($data);
            exit;