SQLize Online / PHPize Online  /  SQLtest Online

create table yapbozKategori ( id int, name varchar(64), bannerUrl varchar(500), price int ); insert into yapbozKategori values (1, 'Category1', 'bannerurl', 20); create table yapboz ( id int,kategoriID int, iconUrl varchar(64), imageUrl varchar(500), bannerUrl varchar(500) ); insert into yapboz values (1, 1, 'iconurl1', 'imgurl1', 'bannerur1'),(2, 1, 'yapboz2', 'imgurl2','bannerur2'), (3, 1, 'iconurl3', 'imgurl4','bannerurl3'); SELECT JSON_ARRAYAGG(JSON_OBJECT( 'id_product', id, 'colors', name, 'url', price )) as json FROM ( SELECT a.id, JSON_ARRAYAGG(b.imageUrl) as colors, a.bannerUrl FROM yapbozKategori as a LEFT JOIN yapboz b ON a.id = b.kategoriID GROUP BY a.id )