从桥表laravel中检索数据

Question

I'm having an issue to retrieve "portion" data from table "ingredient_recipe". Is there any way to get the "portion" data without using Query Builder? This is my code for retrieve ingredient in recipe model. The problem is I want to retrieve portion value from Recipe model.

class Recipe extends Model
{
  public function ingredients(){
        return $this->belongsToMany('App\Ingredient');
  }
}

Answer 1

Add the pivot table column in your relationship

public function ingredients()
{
    return $this->belongsToMany('App\Ingredient')->withPivot('portion');
}

Then access it like

$recipe = Recipe::find(1);

foreach ($recipe->ingredients as $ingredient) {
    echo $ingredient->pivot->portion;
}