mysql 中的update set select 更新语法，要如何做

update  phenix.coupon_hold  h
left join czk_gm.card_order  o on o.mapping_id=h.id
left join czk_hxjt.user_info u on u.user_id=o.user_id
set h.customer_name=u.name,h.customer_mobile=u.phone_num
where h.customer_mobile=''