How to get only relations from eloquent query

Question

I got the following code:

$popularProducts = PopularProduct::with('product')->get();

This is how I get all of products from popular_products (contains only product_id) table with relations for products table. But I have this result:

Collection {#409 ▼
  #items: array:1 [▼
    0 => PopularProduct {#411 ▼
      #connection: "mysql"
      #table: null
      #primaryKey: "id"
      #keyType: "int"
      +incrementing: true
      #with: []
      #withCount: []
      #perPage: 15
      +exists: true
      +wasRecentlyCreated: false
      #attributes: array:4 [▶]
      #original: array:4 [▶]
      #changes: []
      #casts: []
      #dates: []
      #dateFormat: null
      #appends: []
      #dispatchesEvents: []
      #observables: []
      #relations: array:1 [▼
        "product" => Product {#462 ▶}
      ]
      #touches: []
      +timestamps: true
      #hidden: []
      #visible: []
      #fillable: []
      #guarded: array:1 [▶]
    }
  ]
}

I need to take only relations->product field. How can I take it?

Answer 1

You can do it like this

$products = PopularProduct::with('product')->get()->pluck('product');

if you like the result to be keyed you can do it like this

$products = PopularProduct::with('product')->get()->pluck('product','id');

// you can key it with **id** of the table (popularProduct) or by **id_product** of relationship (product)

if you like only to retrieve specific fields from relation you can try something like this

 $products = PopularProduct::with('product:id,product_name')->get()->pluck('product','id');