多表联查 更新语句：

--   最终更新语句------------
UPDATE partner_image_diagnosis pid
	JOIN employee e ON pid.user_id = e.user_id 
	AND e.project_id IS NULL 
	AND e.emp_status = 1
  JOIN org_info oi ON oi.org_id = e.org_id 
	AND org_status = 1 
SET pid.org_id = oi.org_id 
WHERE 
pid.consulting_id IN ( 

SELECT a.consulting_id
FROM (SELECT consulting_id FROM partner_image_diagnosis  WHERE org_id = 0 AND project_id IS NULL ORDER BY consulting_id ASC) as a
	  ) 

注意事项：
where 后面不这样写报如下错误

You can't specify target table 'pid' for update in FROM clause