mysql查询结果按逗号合并

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    subject VARCHAR(100)
);

INSERT INTO students (id, name, subject) VALUES
(1, 'Alice', 'Math'),
(2, 'Bob', 'Science'),
(3, 'Alice', 'Science'),
(4, 'Charlie', 'Math');

SELECT name, GROUP_CONCAT(subject SEPARATOR ', ') AS subjects
FROM students
GROUP BY name;

+-------+------------------+
| name  | subjects         |
+-------+------------------+
| Alice | Math, Science    |
| Bob   | Science          |
| Charlie | Math             |
+-------+------------------+

SET SESSION group_concat_max_len = 1000000;

SELECT name, GROUP_CONCAT(subject ORDER BY subject SEPARATOR ', ') AS subjects
FROM students
GROUP BY name;