GROUP BY subject; 替代写法可以是: SELECT subject, CONCAT('[', GROUP_CONCAT(name SEPARATOR ', '), ']') as names FROM students GROUP BY subject; 这种替代写法将所有的名字连接起来,并在其外部添加了方括号。它将返回以下结果: +++ subject names +++ Math [Alice] Science [Bob] Literature [Charl...