update orders as o
inner join (select o.orderer, p.provider_id from orders o
inner join users u
on o.orderer = u.user_id
inner join provider p on p.person_id = u.person_id) as b
on o.orderer = b.orderer
set o.orderer = b.provider_id