thinkphp 3.2 多表联合查询 group分组

$res = M(‘member’)
->table(‘__MEMBER__ as a’)
->join(‘__ORDER__ as b’)
->field(‘a.id,b.order_sn,count(b.id) as total’)
->where(‘b.receive_member_id = a.id’)
->group(‘a.id’)
->order(‘total desc’)
->limit($page->firstRow, $page->listRows)
->select();

表member和表order联合查询