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