UPDATE
plug_city
inner
join
(
SELECT
area_fullname,ID
FROM
plug_city) c
on
c.ID=plug_city.parent_id2
SET
plug_city.area_fullname= concat(c.area_fullname,plug_city.area_name)
WHERE
plug_city.id=630221;