Consulta SQL para INSERT várias linhas com SELECT

INSERT INTO table2
     (name, email, phone)
     SELECT name, email, phone
     FROM table1;

Fonte:

https://stackoverflow.com/questions/38989691/sql-query-to-insert-multiple-rows-with-select