INSERT INTO orders (customer_id, total_price) VALUES (123, 2500);
SET @order_id = LAST_INSERT_ID();

INSERT INTO order_items (order_id, product_id, quantity, price) 
VALUES (@order_id, 10, 2, 500), (@order_id, 15, 1, 1500);