'How to insert new rows for each foreign key from a table

I want to make a query to add for each user all the id_job, id_role pairs from the user with id 0 (id_user, default user). Is it possible in mysql?

user_role table

id_user id_job id_role
0 1 1
0 2 2
1 1 1
1 2 2
2 3 1

These are the dates I want to get to. As you can see in the first table, for the user with id 2, we don't have id_job and id_role [(1,1), (2,2)] and I want to run a query that populates the missing pairs for this user.

user_role_updated table

id_user id_job id_role
0 1 1
0 2 2
1 1 1
1 2 2
2 3 1
2 1 1
2 2 2

Thank you in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source