SQL INSERT INTO SELECT

INSERT INTO SELECT 语句从一个表复制数据，然后把数据插入到一个已存在的表中。

INSERT INTO Websites (name, country)
SELECT app_name, country FROM apps;

https://www.runoob.com/sql/sql-insert-into-select.html