How to get nested list after SELECT query?

Question

JSON

I make such a query
SELECT docs.date , docTypes.name, docs.id , products.image, products.name , products.price, rows.quantity, products.removed FROM docs , docTypes , products , rows WHERE docTypes.id = docs. typeId
AND docs.id = rows.docId AND rows.productId = products.id GROUP BY products.name HAVING products.removed = 0 ORDER BY date ASC;
I generate such a json file

. What should I change in the request so that a nested list is created for each object?
something like this
block
data
id
....
block
date
id
....