Realizar INSERT INTO a partir de um SELECT (insert from select)

Realizar INSERT INTO a partir de um SELECT (insert from select)

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