mysql - 多行数据合并查询

备注：门店营业时间多条时，合并时间查询

SELECT
	sm.id AS 门店ID,
	sm. NAME AS 门店名称,
	IFNULL(multi_mark, '') AS 门店编码,
	IFNULL(msr. NAME, '') AS 机构,
	per_price AS 人均消费,
	linkman AS 联系人,
	mobile AS 客服电话,
	IFNULL(
		(
			CASE
			WHEN STATUS = 0 THEN
				'未知'
			WHEN STATUS = 1 THEN
				'营业中'
			WHEN STATUS = 2 THEN
				'休息中'
			WHEN STATUS = 3 THEN
				'门店繁忙'
			END
		),
		''
	) AS 营业状态,
	concat(
		'[',
		longitude,
		', ',
		latitude,
		']'
	) AS 坐标,
	IFNULL(
		REPLACE (ss.workweek, '"', ''),
		''
	) AS 门店营业周期,
	IFNULL(
		REPLACE (ss.worktime, '"', ''),
		''
	) AS 门店营业时间
FROM
	sqltakeout.wm_store_multis AS sm
LEFT JOIN sqltakeout.wm_multi_store_regions AS msr ON msr.id = sm.region_id
LEFT JOIN (
	SELECT
		multi_store_id,
		GROUP_CONCAT(workweek SEPARATOR ' || ') AS workweek,
		GROUP_CONCAT(worktime SEPARATOR ' || ') AS worktime
	FROM
		sqltakeout.wm_store_saletimes
	WHERE
		category = 1
	GROUP BY
		multi_store_id
) AS ss ON sm.id = ss.multi_store_id
WHERE
	sm.store_id = 10155;