update user1 as a,user2 as b set a.over='齐天大圣' where a.user_name=b.user_name;
update user1 set over='xx' where user_name=(select user_name from user2) 这样会不会好点?