get all manufacturer_id with groupby

i have a category model with products :

        public function products(){
             return $this->morphedByMany('App\Models\Product', 'categorized', 'categorized');
          }

and i have a products model with manufacturer by manufacturer_id in my db:

    public function manufacturer()
      {
            return $this->belongsTo('App\Models\Business', 'manufacturer_id')-  >where('manufacturer', true);
      }

how i can get a list for all the manufacturer belogs to products in this spesipic category

this how i go the product in the category:

$category->products()->get();

thanks

haizone

8 years ago

Level 2

i do that but maybe have a better and fast option?

$manufacturers = new Collection;
    foreach ($category->products()->get() as $value) {
      $manufacturers->push($value->manufacturer);
    }

    $manufacturers = $manufacturers->unique()->all();

jlrdw

8 years ago

Level 75

Have you worked the example from docs, https://laravel.com/docs/5.6/queries#ordering-grouping-limit-and-offset

Please or to participate in this conversation.