mysql 子查询

update `tem_wf_administrative_region` a,
(select b.`ROW_ID` as P, b.parentName from `tem_wf_administrative_region` b)c
set a.parent_id = c.P
where a.parent_id=c.`parentName`;