- $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();
转载于:https://www.cnblogs.com/zonglonglong/p/7534988.html