CREATE TABLE categories (
id INT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
parent INT
);
INSERT INTO categories (id, name, parent) VALUES
(1, 'shoes', 0),
(2, 'women_shoes', 1),
(3, 'man_shoes', 1),
(4, 'sweets', 0),
(5, 'man_sweets', 4),
(6, 'women_sweets', 4),
(7, 'women_red_sweets', 6),
(8, 'women_green_sweets', 6),
(9, 'men_blue_sweets', 5);