mysql 查询后更新 update select

模型如下

UPDATE bkb_seller bs 
INNER JOIN (
  # 查询语句
  SELECT new_user,seller_id,create_time from lc_seller_change_history  
  where  id = 11
) a 
# 更新语句
SET bs.user_id =a.new_user,bs.create_time = a.create_time 
where bs.id = a.seller_id