mysql 聚合group by列之后排序并且指定分隔符 separator

SELECT
	GROUP_CONCAT( bf.factor_en_name ORDER BY bf.factor_code ASC SEPARATOR '/' ) AS pcApplicationSettings 
FROM
	bx_well_device bwd
	LEFT JOIN bx_well_device_factor bwdf ON bwd.device_id = bwdf.device_id 
	AND bwdf.del_flag = '0'
	LEFT JOIN ( 
        SELECT factor_id, factor_name, factor_en_name,
        factor_code FROM bx_well_factor WHERE del_flag = '0' 
        ORDER BY create_time DESC ) bf ON bf.factor_id = bwdf.factor_id 
WHERE
	bwd.del_flag = '0' 
GROUP BY
	bwdf.device_id