聚类函数string_agg在Mysql中可以用GROUP_CONCAT来代替 SELECT GROUP_CONCAT(brandId, ":", company) from base_car GROUP BY brandId