select * from
(select member_id,member_name from tb_member where store_id =1) a
left join
(SELECT buyer_id,count(*) order_num,sum(order_amount) order_amount FROM tb_orders wher store_id = 1 GROUP BY buyer_id) b
on a.member_id=b.buyer_id
左链接查询可以从一条sql语句的查询结果集链接,可以将不同的sql语句的结果集组合在一起。