SQLize Online / PHPize Online  /  SQLtest Online

create TABLE pizzas( id VARCHAR(255) PRIMARY KEY, name VARCHAR(255), img VARCHAR(255) ); insert into pizzas values (1, 'Margarita', 'pizza.jpg'); create TABLE pizzas_dough( id SERIAL PRIMARY KEY, traditional BOOLEAN DEFAULT true, thin BOOLEAN DEFAULT true, pizza_id VARCHAR(255), FOREIGN KEY (pizza_id) REFERENCES pizzas (id) ON DELETE CASCADE ); insert into pizzas_dough values (1, True, False, 1), (2, True, True, 1); select p.*, json_agg (row_to_json(pd.*)) pizzas_doughs from pizzas p join pizzas_dough pd on p.id = pd.pizza_id group by p.id;