Food with FoodType by food name in DB

Result: SQL executed.

SELECT *, food.id AS _food__id, food_type.id AS _food_type__id, food.name AS _food__name, food_type.name AS _food_type__name,  food_type.id AS _food_type__id
                    FROM food
                    
                    LEFT OUTER JOIN food_type
                    ON food.food_type_id = food_type.id
                    WHERE food.name LIKE '%Nasi Lemak%'
                      

Food Object
(
    [id] => 4
    [name] => Nasi Lemak
    [description] => A kind of rice made with coconut milk
    [location] => Malaysia
    [food_type_id] => 4
    [_table] => food
    [_primarykey] => id
    [_fields] => Array
        (
            [0] => id
            [1] => name
            [2] => description
            [3] => location
            [4] => food_type_id
        )

    [FoodType] => FoodType Object
        (
            [id] => 4
            [name] => Rice
            [_table] => food_type
            [_primarykey] => id
            [_fields] => Array
                (
                    [0] => id
                    [1] => name
                )

        )

)