INSERT INTO provider(person_id, identifier, creator, date_created, retired, uuid)
SELECT (SELECT distinct orderer from orders), users.username, users.creator, users.date_created, users.retired, users.uuid
FROM users
WHERE users.user_id NOT IN (SELECT provider_id FROM provider)