ThinkPHP联表查询

$list = db($pnav['ename']) -> field('a.*,b.name as pname') ->alias('a') -> join('sbl_nav b','a.pid = b.id') ->  where('a.status = 1')->order('date desc')->paginate(10);

 

posted @     阅读(581)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示