mysql中，第二天语句有些问题，并且语法有些难以理解

update user1 a join(

select b.user_name

from user1 a inner join user2 b on

a.user_name=b.user_name

)b on a.user_name=b.user_name

set a.[over]='齐天大圣'