Inserting multiple rows into MySQL when creating a new product in PHP for multi-location sales

I’m working on a stock management system USING PHP,Mysql,Jquery everything works fine but i cant get figured out how to create multiple MYSQL rows with php when creating a new product.

I do have 3 tables since i have a product at different sales locations here are my tables

// product table
SELECT pro_id, pro_name, pro_buy, pro_sell, pro_status FROM pro_set

// product locations
SELECT loc_id, loc_name, loc_status FROM pro_loc

// product quantity table
SELECT id, pro_id, loc_id, pro_qty FROM pro_qty

Now i am trying to get it work that if i do create a new product, it will create 5 rows in table pro_qty with my location id’s inside the pro_qty.loc_id since i have 5 locations.