Add a subselect based on relationship using withAggregate method

• Add a subselect based on relationship using withAggregate in Laravel

  Syntax :

  $posts = App\Models\Post::withAggregate('user', 'email')->first();
  

  Code Example : //app\Models\Post.php

  <?php
  
  namespace App\Models;
  
  use Illuminate\Database\Eloquent\Factories\HasFactory;
  use Illuminate\Database\Eloquent\Model;
  
  class Post extends Model
  {
      public function user()
      {
          return $this->belongsTo(User::class);
      }
  }
  

  routes\web.php

  Route::get('/subselect-with-aggregate', function(){
      $posts = App\Models\Post::withAggregate('user', 'email')->first();
      dd($posts);
  });
  

  Output :

  [▼
      "id" => 11
      "title" => "Labore do commodi et"
      "body" => "Lorem ipsum"
      "user_id" => 1
      "created_at" => "2021-10-13 05:10:23"
      "updated_at" => "2021-10-13 05:10:23"
      "user_email" => "john@example.com"
  ]

  You can get the email of user who created the post using user_email after getting the data from table.

Back to code snippet queries related laravel