你需要string_agg，所以应该是this-

SELECT 
    sr_number, name,
    string_agg(city, ', ') WITHIN GROUP (ORDER BY city) AS city
FROM 
    table_name
GROUP BY 
    sr_number, name;