Inserting Hierarchical Rows Duplicate Error

Hi there,

When trying to run the following queries

INSERT INTO orders(customer_id, order_date, status)
VALUES (1, “2020-01-02”, 3);

INSERT INTO order_items
VALUES
(LAST_INSERT_ID(), 1, 1, 2.95),
(LAST_INSERT_ID(), 1, 1, 3.95);

I get an error on the execution of the second query.
Error Code: 1062. Duplicate entry ‘11-1’ for key ‘order_items.PRIMARY’ 0.000 sec

Any idea?
Thanks