MYSQL 列转行

SELECT 
  a.col1,
  a.col2,
  SUBSTRING_INDEX(
    SUBSTRING_INDEX(a.datad, ',', s.`seq`),
    ',',
    - 1
  ) AS aaa 
FROM
  (SELECT 
    col1,
    col2,
    SUBSTRING_INDEX(
      GROUP_CONCAT(NAME 
        ORDER BY data_time),
      ',',
      5
    ) AS datad 
  FROM
    `test` 
  GROUP BY col1,
    col2) a 
  JOIN sequce s 
    ON s.`seq` <= (
      LENGTH(a.datad) - LENGTH(REPLACE(a.datad, ',', '')) + 1
    ) 
ORDER BY a.col1,
  a.col2 ;