UPDATE org_personnel_duty tc
INNER JOIN(select op.id id,op.per_name,op.host_post host_post,opd.org_dept_duty_id,opd.id ids
from org_personnel_duty opd
LEFT JOIN org_personnel op on op.id = opd.org_personnel_id
where op.multi_tenancy_id like '%10001%') t ON tc.org_personnel_id = t.id
SET tc.org_dept_duty_id=t.host_post