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);