mysql group_concat

用户的特地优惠券列表明细

select uid,group_concat(coupons.price SEPARATOR '+') as '优惠券明细',sum(coupons.price) as '合计金额' from `user_coupons` 
inner join coupons on coupons.`id`=user_coupons.`coupon_id`
where user_coupons.pid=1 
AND user_coupons.state=1 
AND user_coupons.expire_at>NOW()
and user_coupons.uid in (select uid from `project_users` where pid=1 AND json_search(tag_ids,'all','2') is not null) 
AND user_coupons.coupon_id in (select id from `coupons` where use_type='new_agent1')
group by uid