title: How to retrieve specific column value from foreign key table?
body: <p>There are two Models. One is <code>TradeLicence</code> and another is <code>BusinessCategory</code>.
  I have already established relationship between them. In <code>TradeLicence</code> there is a foreign key <code>category_id</code> which local key is <code>id</code> of <code>BusinessCategory</code>.</p>
  <p>Trade Licence Model</p>
  <pre><code>class TradeLicence extends Model
  {
      use SoftDeletes;
  
      protected $fillable = ['slug', 'name', 'category_id'];
  
      public  function businessCategories()
      {
          return $this-&gt;belongsTo(BusinessCategory::class,'category_id','id');
      }
  
  }
  </code></pre>
  <p><code>trade_licences</code> migration Table:</p>
  <pre><code>    class CreateTradeLicencesTable extends Migration
  {
  
      public function up()
      {
          Schema::create('trade_licences', function (Blueprint $table) {
              $table-&gt;id();
              $table-&gt;string('slug')-&gt;unique();
  
              $table-&gt;foreignId-&gt;('category_id');
              $table-&gt;string-&gt;('name');
  
              $table-&gt;timestamps();
          });
       }
  }
  </code></pre>
  <p>Business Category Model:</p>
  <pre><code>class BusinessCategory extends Model
  {
      use SoftDeletes;
  
      protected $fillable = ['slug', 'name', 'fees'];
  }
  </code></pre>
  <p><code>business_categories</code> migration table:</p>
  <pre><code>class CreateBusinessCategoriesTable extends Migration
  </code></pre>
  <p>{</p>
  <pre><code>public function up()
  {
      Schema::create('business_categories', function (Blueprint $table) {
          $table-&gt;id();
          $table-&gt;string('slug')-&gt;unique();
  
          $table-&gt;string('name');
          $table-&gt;double('fees');
  
          $table-&gt;timestamps();
      });
  }
  </code></pre>
  <p>For adding a &quot;Trade Licence&quot;, I need to select a &quot;Business Category&quot; and it stores the value
  in<code>category_id</code> column of <code>trade_licences</code>table. I'm able to retrieve the <code>name</code> and <code>fees</code> value through the relationship inside <code>TradeLicense</code> model.</p>
  <p>The problem is:</p>
  <p>There is a another Model named <code>DailyEarning</code>. The <code>show()</code> method of <code>DailyEarningController</code> will display <code>fees</code> amount (fee of selected category, which was selected at the time of creating a new trade licence) and <code>created_at</code> and <code>updated_at</code> value of each Trade License.</p>
  <p>My Question is:</p>
  <p>How to get the values of <code>fees</code>, <code>created_at</code> and <code>updated_at</code> or which Query should I use to retrieve the values  by using &quot;Eloquent&quot;?</p>