UPDATE table1 as a ,
(
SELECT
user_name,user_staff_id
FROM
table2
GROUP BY user_staff_id
)as b
SET a.user_name = b.user_name
WHERE
a.create_user = b.user_staff_id
set 和where 之间不能用到子查询,但是update之后可以,update相当于from