select GROUP_CONCAT(a.send_order_id) as send_order_id,b.partner_user_id as partner_user_id, sum(a.need_pay_amount) as num from send_order a join send_order_extend b on a.send_order_id = b.send_order_id
where a.order_import_time>'2019-05-21' group by b.partner_user_id HAVING sum(a.need_pay_amount) > 1000
但是GROUP_CONCAT()这种方式有个很大的问题就是返回字符串的长度默认最大长度是1024,超过1024字节,字符串将被截断。所以要慎重使用