MySQL数据库同时查询更新同一张表的方法

UPDATE tbl_taskfilling_student a JOIN
(SELECT userId,classes FROM tbl_taskfilling_student WHERE taskFillingId=166) b ON a.userId=b.userId
SET a.classes=b.classes
WHERE a.taskFillingId=172