mysql查询出某个id拼接 并且修改

UPDATe station_meter 
SET meter_users = (
	SELECT
		CONCAt( ',', GROUP_CONCAt( relation_user ), ',' ) 
	FROM
		station_relation
		INNER JOIN station ON station_id = relation_station 
		WHERe station_id = meter_station 
	)


UPDATe station 
SET station_users = (
	SELECT
		CONCAt( ',', GROUP_CONCAt( relation_user ), ',' ) 
	FROM
		station_relation 
WHERe
	relation_station = station_id)