mysql update select 多個字段

update `order` o LEFT JOIN
(SELECT t1.id as orderid,t1.applayId,t3.id as appdepid,t3.name as applayName FROM `order` t1
 LEFT JOIN sys_userlinkdep t2 on t1.applayId=t2.userid
 LEFT JOIN sys_department t3 on t2.depid=t3.id) as t
on o.id=t.orderid 
set o.beiyong2=t.applayId,o.beiyong3=t.applayName;