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;