$list = $kb -> field('kid as id,ktime as time,kname as name,kphone as phone,kqq as qq,kweixin as weixin,qicon as icon,qqudao as qudao,qid,ksort as sort,ttype as type,ktrack as track,a.uname as jiedai,b.uname as wanxiao,sstatus as status,sid,scolor as color,kding as ding')
-> join('LEFT JOIN user a ON kezi.kjiedai = a.uid')
-> join('LEFT JOIN user b ON kezi.kwanxiao = b.uid')
-> join('LEFT JOIN type ON kezi.ktype = type.tid')
-> join('LEFT JOIN status ON kezi.kstatus = status.sid')
-> join('LEFT JOIN qudao ON kezi.kqudao = qudao.qid')
-> where($cha) -> order('ktime desc') -> limit($limit) -> select();
$this -> assign('list',$list); 最佳答案
