UPDATE orders
    SET orderer = (SELECT orderer
FROM orders
WHERE orderer
IN (

SELECT person_id
FROM users
)
AND orderer
IN (

SELECT user_id
FROM users
))