Recipe by food name in DB

Result: SQL executed.

SELECT * FROM food WHERE name LIKE '%Nasi Lemak%'   LIMIT 1

SELECT *, recipe.id AS _recipe__id, food.id AS _food__id, recipe.description AS _recipe__description, food.description AS _food__description,  food.id AS _food__id
                    FROM recipe
                    
                    LEFT OUTER JOIN food
                    ON recipe.food_id = food.id
                    
                      

Recipe Object
(
    [id] => 1
    [description] => Bring water to a boil. Add all the herbs and simmer for 30 minutes. Add (fried) vegetarian rib bones, meatballs and the dried and button mushrooms. Cook for 10 minutes. Add wong nga pak and golden mushrooms and cook for five to six minutes.
    [food_id] => 7
    [_table] => recipe
    [_primarykey] => id
    [_fields] => Array
        (
            [0] => id
            [1] => description
            [2] => food_id
        )

    [Food] => Food Object
        (
            [id] => 7
            [name] => Bak Kut Teh
            [description] => A Chinese soup popularly served in Malaysia, Singapore originated in Klang valley. Usually served with pork but sometimes seafood & even vegetarian style
            [location] => Malaysia
            [food_type_id] => 3
            [_table] => food
            [_primarykey] => id
            [_fields] => Array
                (
                    [0] => id
                    [1] => name
                    [2] => description
                    [3] => location
                    [4] => food_type_id
                )

        )

)