with cte1 as
(
select '10084' as  hostid,'127.0.0.1' as ip
union all
select '10436' as  hostid,'192.168.10.131' as ip
union all
select '10439' as  hostid,'192.168.10.127' as ip
union all
select '10448' as  hostid,'192.168.10.130' as ip
)
select  group_concat(hostid separator ' ') from cte1 
union all
select group_concat(ip separator ' ')  from cte1

结果
10084 10436 10439 10448
127.0.0.1 192.168.10.131 192.168.10.127 192.168.10.130