我有两个mysql查询，我使用union组合了它们。我得到了我想要的结果。但是，我想知道是否有一种方法可以组合具有相同名称的字段。例如，我从图像中的第一个表中获取结果。我想做的是将两个名为“test”的promo字段合并到一个字段中，并添加三列（free、none、pay）。我想要的结果在第二个表中。

这是我的问题

select users.refer as promo, 
                            count( case when plan = 'free' then 1  end ) as free,
                            count( case when plan = '' then 1 end ) as none,
                            count( case when plan <> 'free' and plan <> '' then 1 end) as pay,
                            promos.status as status
                            from users
                            inner join promos on users.refer = promos.name
                            where refer <> ''
                            group by refer
Union 
select subscriptions.promo as promo,
                            count( case when plan = 'free' then 1  end ) as free,
                            count( case when plan = '' then 1 end ) as none,
                            count( case when plan <> 'free' and plan <> '' then 1 end) as pay,
                            promos.status as status
                            from subscriptions
                            inner join promos on subscriptions.promo = promos.name
                            inner join users on subscriptions.user_id = users.id
                            where promo <> ''
                            group by promo