$members=$model->table('zhope_card A')
->join('zhope_user U ON A.adduser=U.id')
->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();生成如下SQLSELECT A.id AS I,A.cid AS Card_id,U.name AS Creator,T.name AS Tpl_name FROM zhope_card A INNER JOIN zhope_user U ON A.adduser=U.id INNER JOIN zhope_tpl T ON A.tpl=T.id因为的字段可以为空所以 需要用LEFT JOIN 最佳答案
