不废话了,直接撸码:
$list=M('commission')->alias('cm')->field('cm.id,cm.commissions,cm.status,ap.username')
->join('LEFT JOIN __PROJECT__ pr ON cm.pro_id=pr.id')
->join('LEFT JOIN __APPLYUSER__ ap ON cm.apply_id=ap.id')
->join('LEFT JOIN __USER__ ur ON cm.userid=ur.id')
->where(array('cm.id'=>$id))->find();
更多技术问题,前往:http://sucai.gxyourui.cn/Home/Article/blog_detail/article_id/53.html