如何在mysql查询中将10行拆分为2列

SELECT 
    t1.column1, t2.column1
FROM
    (SELECT 
        column1, (@row_number:=@row_number + 1) AS row_number
    FROM
        table_name, (SELECT @row_number:=0) AS t
    WHERE
        (@row_number DIV 5) % 2 = 0) AS t1
        LEFT JOIN
    (SELECT 
        column1, (@row_number:=@row_number + 1) AS row_number
    FROM
        table_name, (SELECT @row_number:=0) AS t
    WHERE
        (@row_number DIV 5) % 2 = 1) AS t2 ON t1.row_number = t2.row_number