update mdm_region mr set parent_ids = (
WITH RECURSIVE cte AS (
SELECT id, parent_id
FROM mdm_region
WHERE id = mr.id
UNION ALL
SELECT n.id, n.parent_id
FROM mdm_region n
JOIN cte on n.id = cte.parent_id
)
SELECT GROUP_CONCAT(parent_id ORDER BY parent_id asc)
FROM cte)