通过两个表的联查结果将一个表的数据批量导入到另一个表中

例子：

UPDATE zhr_risk_point_supervisor AS super
JOIN user AS u
ON super.user_name = u.cn AND (super.user_ipa is NULL OR user_id is NULL)
SET super.user_ipa = u.name, super.user_id = u.id;

通过将量表相连，再从连接的结果向原表进行更新