Get data from 3 tables with relationship

You could look over some of these, as this a such a common question:

https://laracasts.com/discuss?q=3+tables

Thank you for your prompt answer @jlrdw.

I know that this is a common question when someone is starting with Laravel and I already searched in this site and other sources of information, but I'm not unable yet to resolve my question.

Mostly i'm getting this error:

Relationship method must return an object of type Illuminate\Database\Eloquent\Relations\Relation

The code that i'm implementing on my User model is something like this:

public function region()
{
    $region = Region::find(1)->cities()->get();

    return $region;
}

Thank you for your help.

@iscromanpc

City Model

public function region() {
    return $this->belongsTo('App\Region');
}

Now you can access the region name for the user as:

$user = User::find(1)->city()->region->name

[code not tested]

public function region()
{
    $user = User::find(1)->city()->region->name;

    return $user;
}

I'm getting and error with your solution implemented on my model:

Undefined property: Illuminate\Database\Eloquent\Relations\BelongsTo::$region

What you suggest, should be implemented on the User model?

How I should return the value $user to be available on my User view?

Thank you @kirankrishnan

@iscromanpc Note, it is not "BelongsTo", It is "belongsTo"

Laravel documentation is very easy to understand, you can go through the views related things here https://laravel.com/docs/5.5/views

I was abble to fix it with the help of one friend.

Finally I'm getting the data from one user, in my controller using something like:

$user = \DB::table('user') ->select( 'user.id', 'user.name', 'city.name as city_name', 'region.name as region_name') ->leftJoin('city', 'user.city_id', '=', 'city.id') ->leftJoin('region', 'city.region_id', '=', 'region.id') ->where('operator.id', '=', $id)->first();

Thanks for try to help me.

The @kirankrishnan is correct, the way you are doing the things with the left join is complicated, In you City Model add this lines:

class City extends Model
{
    public function region() {
            return $this->belongsTo('App\Region');
    }
}

class User extends Model
{
    public function city() {
            return $this->belongsTo('App\City');
    }
}

$region_name = User::find(1)->city->region->name