Bulk Insert is characterized by high speed:

INSERT INTO a VALUES (1,23),(2,34),(3,33);

If there is still a B table with foreign keys of A table, is there any way to insert A and B tables in batch at the same time?

Table structure:

Table a

Id
 Name

Table b

Id
 a_id
 Name

If the form of batch insert B table is:

INSERT INTO b VALUES (1,1,11),(2,1,12),(3,1,13),(4,2,21),(5,2,22),(6,2,32),(7,3,31),(8,3,32),(9,3,33);