To form a long query in the database?

Question

MySQL

DB - MySQL. Hundreds of rows need to be inserted in a single query, and the third parameter must be taken from an adjacent table. How to generate a query through a loop?
var sql = "INSERT INTO person (id, name, school) VALUES (?, ?, (SELECT id FROM school WHERE number='?'))";

Answer 1

INSERT INTO person (id, name, school) 
SELECT id, ... AS name, ... AS school FROM school WHERE ...