假设您有一种排序数据的方法，您可以生成行号并将奇数行与偶数行连接起来

drop table if exists t;
create table t(value int, id varchar(2));

insert into t values
(10   ,  'x1'),
(20   ,  'x2'),
(15   ,  'x3'),
(25   ,  'x4'),
(30   ,  'x5'),
(31   ,  'x6');

select s.*,a.*
from
(select id, value , 
         @rn:=@rn + 1 rn
from t
cross join (select @rn:=0) r
order by id
) a
join
(
select id, value , 
         @rn1:=@rn1 + 1 rn1
from t
cross join (select @rn1:=0) r
order by id
) s
on s.rn1 = rn + 1
where a.rn % 2 > 0
;
+------+-------+------+------+-------+------+
| id   | value | rn1  | id   | value | rn   |
+------+-------+------+------+-------+------+
| x2   |    20 |    2 | x1   |    10 |    1 |
| x4   |    25 |    4 | x3   |    15 |    3 |
| x6   |    31 |    6 | x5   |    30 |    5 |
+------+-------+------+------+-------+------+
3 rows in set (0.00 sec)