join query result in multidimensional array

[eluser]mysterious[/eluser]
menu_item item_id, category_id, subcategory_id,name, order
menu_item_size item_size_id, item_id,size, price,order

using following query

Code:

SELECT
menu_item.item_id AS item_id,
menu_item.name AS item_name,
menu_category.name AS category_name,
menu_subcategory.name AS subcategory_name,
menu_item_size.size,
menu_item_size.price,
menu_item_size.item_size_id
FROM
menu_item
Left Join menu_category ON menu_item.category_id = menu_category.category_id
Left Join menu_subcategory ON menu_item.subcategory_id = menu_subcategory.subcategory_id
Left Join menu_item_size ON menu_item.item_id = menu_item_size.item_id
ORDER BY
menu_category.order ASC,
menu_subcategory.order ASC,
menu_item.order ASC,
menu_item.name ASC,
menu_item_size.order ASC

fetches an array in this way:

pizza1 large 10
pizza1 medium 7
pizza1 family 13
pizza2 large 12
pizza2 small 8

then i use some php logic to create an array of this type:

Code:

pizza1 size(
    array( size=>large,price=>10),array(size=>medium, price=>7),array(size=>family,price=>13)
)

pizza2 size(
    array( size=>large,price=>13),array(size=>small, price=>8)
)

is there a way to fetch records in this kind of array or object. I think i have seen this somewhere. may be in doctrine. Is it possible in codeigniter as well ??