将两行合并为一行mysql

SELECT GROUP_CONCAT(column_name SEPARATOR ', ') AS merged_column
FROM table_name
WHERE condition;

+----+-------+
| id | name  |
+----+-------+
| 1  | Alice |
| 2  | Bob   |
+----+-------+

SELECT GROUP_CONCAT(id SEPARATOR ', ') AS merged_id,
       GROUP_CONCAT(name SEPARATOR ', ') AS merged_name
FROM students;

+-----------+-------------+
| merged_id | merged_name |
+-----------+-------------+
| 1, 2      | Alice, Bob  |
+-----------+-------------+