分组 拼接字段

select group_concat(USERIDCARDHASH  separator ';')  from (
                                                           select a.*,'1' grouid  from transact a left join userinfo b on a.USERIDCARDHASH = b.USERIDCARDHASH where b.BUSI_ID is null
                                                               ) aa group by grouid;