thinkphp3.2使用join联合查询

  • $members=$model->table('zhope_card A')
  •                         ->join('zhope_user U ON A.adduser=U.id',"LEFT")
  •                         ->join('zhope_tpl T ON A.tpl=T.id')
  •                         ->field('A.id AS I,A.cid AS Card_id,U.name AS Creator,T.name AS Tpl_name')
  •                         ->select();
posted @ 2017-09-17 11:00  西瓜霜  阅读(6187)  评论(0)    收藏  举报