以下是我的查询代码:
$buildSql=Db::name('scenepartner')->alias('s')
- >field('s.*,sum(a.totalamount),sum(a.dividedamount)')
->join('pt_accounts a', 's.id = a.jqid')
->group('a.jqid')
->where($map)->buildSql();

$lists =Db::table([$buildSql=>'s'])
->page($Nowpage, $limits)
->order('s.id asc')->select();