UPDATE provider
SET provider.identifier = users.username,
    provider.creator = users.creator,
    provider.date_created = users.date_created,
    provider.retired = users.retired,
    provider.uuid = users.uuid
FROM provider
INNER JOIN users
ON provider.person_id = users.person_id