MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `users` (
  id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(60) NOT NULL
);

CREATE TABLE products (
  id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(60)  NOT NULL,
  description VARCHAR(255) NOT NULL,
  price DECIMAL(6,2) NOT NULL
);

CREATE TABLE orders (
  id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  user_id MEDIUMINT UNSIGNED NOT NULL,
  date DATETIME  NOT NULL,
  status VARCHAR(20) NOT NULL
);

CREATE TABLE orders_products (
  order_id MEDIUMINT UNSIGNED NOT NULL,
  product_id MEDIUMINT UNSIGNED NOT NULL,
  quantity TINYINT UNSIGNED NOT NULL,
  price DECIMAL(6,2) NOT NULL,
  PRIMARY KEY (order_id, product_id),
  INDEX (product_id, order_id)
);

INSERT INTO users VALUES
  (1, 'User 1'),
  (2, 'User 2');

INSERT INTO products VALUES
  (1, 'Product 1', 'descr', 55),
  (2, 'Product 2', 'descr', 65),
  (3, 'Product 3', 'descr', 45),
  (4, 'Product 4', 'descr', 75);

INSERT INTO orders VALUES
  (1, 1, '2022-01-18 21:03:22', 'new'),
  (2, 2, '2022-01-18 21:07:03', 'new');

INSERT INTO orders_products VALUES
  (1, 1, 1, 55),
  (1, 2, 1, 65),
  (1, 3, 1, 45),
  (2, 2, 1, 65),
  (2, 4, 1, 75);

Records: 2  Duplicates: 0  Warnings: 0

Records: 4  Duplicates: 0  Warnings: 0

Records: 2  Duplicates: 0  Warnings: 0

Records: 5  Duplicates: 0  Warnings: 0

id	name	description	price
1	Product 1	descr	55.00
2	Product 2	descr	65.00
3	Product 3	descr	45.00

id	name
1	User 1
2	User 2