Ok to make it more clear: I am Using doctrine
Ben bir tablo Markalar ve Ürünleri var
Brand
id
name
Product
id
name
brand_id
I have a lot of brands and Products of those brands in the database. I would like to retrieve List of brands(+ count of its products) Grouped by Brand.name's first latter.
ex:
array(
n => array(
0 => array('Nike', 4 ),
1 => array('North Pole', 18)
.....
)
.....
)
So my question was can this be done with one query in a efficient way. I really don't wan't to run separate queries for each brand.name's first latter. Doctrines "Hierarchical Data" cross my mind but I believe it for different thing?. thanks