Doubt between relationships with Laravel and Eloquent

Question

I have the following model, using Laravel 5.8

I ran all the records and structured the relationships. On my Dashboard I need to list in card form all reports from a specific user. How could I do this?

So far I can get all of that user’s groups doing this:

$obj = User::with('grupos')->get();

However, how can I access the other table and get to the report? I tried to do something like this:

$obj = User::with('grupos', 'relatorios')->get();

However, the relationship is in another table can not list the data

User model

<?php

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    use Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password','cliente_id'
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];

   public function cliente()
   {
       return $this->belongsTo('App\models\Cliente');
   }

   public function grupos(){
       return $this->belongsToMany("App\models\Grupo", "acessos");
   }
}

Answer 1

You’ll have to change that line:

$obj = User::with('grupos', 'relatorios')->get();

for that:

$obj = User::with('grupos.relatorios')->get();

Whereas in the model grupos has to have the declaration of a relationship with relatorios.

When you use the first form, the class understands that there is a direct relationship with the other, but in your model you can only make the relationship with the class groups and customers.

The statement form of this line is wrong, the correct is:

$obj = User::with(['grupos', 'relatorios'])->get();