Как лучше реализовать логику вычисления данных из таблиц?

$recipe_ingridient_groups = RecipeIngridientGroup::where('recipe_id', $id)->get();

@foreach($recipe_ingridient_groups as $key => $value)
@foreach($value->ingridients() as $ingridient_key => $ingridient_value)
{{ $ingridient_value->ingridient()->name }}

SELECT `i`.`name` AS `ingredient`, `ri`.`amount`, `u`.`name` AS `units`, 
       `ri`.`amount` * `g`.`weight` AS `grams`
  FROM `recipe_ingredients` AS `ri`
  JOIN `ingredients` AS `i` ON `i`.`id` = `ri`.`ingredient_id`
  JOIN `units` AS `u` ON `u`.`id` = `ri`.`units_id`
  LEFT JOIN `gram_per_unit` AS `g`
    ON `g`.`ingredient_id` = `i`.`ingredient_id` 
      AND `g`.`units_id` = `i`.`units_id`
  WHERE `ri`.`recipe_id` = :recipeId