Im trying to duplicate rows in my tables while keeping the same link between them.

Im using PGSQL. I will explain with examples.

Employer table:

I want to duplicate specific rows, based on its ServiceProviderID while changing only ServiceProviderID.

This is how I achieved it:

INSERT INTO employer (name, service_provider_id, updated_at)
SELECT name, 999, updated_at
FROM employer
WHERE service_provider_id = 11
RETURNING id;

It will result in both Microsoft and Meta rows being duplicated, because they have ServiceProviderID=11, but with ServiceProviderID changed to 999

However, on my Worker table, I cant figure out how to map them to the newly inserted Employer.

Worker table:

If I run below code:

INSERT INTO worker (name, service_provider_id, employer_id)
SELECT name, 999, employer_id
FROM worker
WHERE service_provider_id = 11
RETURNING id;

The employer_id will still be the same it was on the original worker row. But I need it to be the newly inserted employer_id it was associated to. How can I do that?