Exemplo de query que realiza a inserção em uma tabela apartir de uma query INSERT INTO blablas (id, name , created_by, created_at, updated_at) SELECT DISTINCT ff . blabla_id , CONCAT ( "blablaulário de com concat " , t . name ), 1 , "2022-10-26 14:31:47" , "2022-10-26 14:31:47" FROM blablas_fields ff INNER JOIN outro_blabla t on t . blabla_id = ff . blabla_id WHERE ff . blabla_id NOT IN ( select id from blablas f) GROUP BY ff . blabla_id Mais em: https://www.w3schools.com/sql/sql_insert_into_select.asp