How to retrieve models from a list of id in a document ?

Hello,

I'm currently trying to build a relationship to retrieve a list of Ingredients in my Recommendation model but it doesn't seem to work and I'm starting to think that my data organization isn't made to suits Laravel features.

How can I retrieve all the ingredients models contained in the results array of a Recommendation ? Is a pivot table mandatory at this point ?

Recommendation Model

 class Recommendation extends Moloquent
    {
        protected $collection = 'recommendations';

        public function ingredients()
        {
            return $this->hasMany(Ingredient::class, 'results.ingredient_id', '_id');
        }
    }

Ingredient Model

class Ingredient extends Moloquent
    {
        protected $collection = 'ingredients';

        public function recommendation()
        {
            return $this->belongsTo(Recommendation::class);
        }
    }

JSON format Recommendation

{
       "_id" : ObjectId("123"),
       "user_id" : "321",
       "results" : [ 
          {
            "ingredient_id" : "1",
            "selected" : true
          }, 
          {
            "ingredient_id" : "2",
            "selected" : false
          }, 
          ...
        ]
     }

JSON format Ingredient

 {
        "_id" : "1",
        "name" : "Phthalates",
        "description" : "Phthalates are a group of..."
    }

mongodb / laravel-mongodb

How to retrieve models from a list of id in a document ? #1387