How to store the list of ordered goods?

Question

MySQL

Let 's say the user made an order and in the "orders" table there is
-order
id -order
amount -order date
etc.
If there was one product, then its id would be stored.
But what to do if there are several products in the order? And what if I ordered 2 pieces or more of one product? How to organize it correctly?

Answer 1

A table purchases(purchases) is created with the fields: