完整sql:
select
sum.id,
group_concat(recipient_group_id order by recipient_group_id separator ",") as group_ids
from(
SELECT
rec.id as id,
recm.recipient_group_id as recipient_group_id
FROM ospdb.t_notification_recipient rec
left join ospdb.t_notification_recipient_group_member recm on rec.id =recm.recipient_id
) sum
group by sum.id