eloquent multiple joins

Whats wrong with Area::with('province', 'province.country')->get();

can i select some fields with aliases like query builder

ex. select areas.id AS aid and provinces.id AS pid

Why would you want to do that?

i want to show them on a datatable and just some fields only and there is some fields are the same name in the 3 tables like id,name

that's why

if you eager load them then the collection will b nested so the name clashes will not matter

i know they are nesting

but im using laravel datatable https://datatables.yajrabox.com/

and in order to show the data on the table i have to write 2 things or every column like this

{data: 'id', name: 'posts.id'},
{data: 'title', name: 'posts.title'},

how i can specify the data and name for fields i want in this case ?

Just reference the nested data through dotted notation?

ie area.province.name or area.province.id

Fun fact: You can Eager Load using closures:

Area::select([
    'id',
    'province_id',
    '<column> AS <alias>',
    /* ... */
])->with([
    'province' => function($query) {
        return $query->select([
            'id',
            'country_id',
            '<column> AS <alias>',
            /* ... */
        ]);
    },
    'province.country' => function($query) {
        return $query->select([
            'id',
            '<column> AS <alias>',
            /* ... */
        ]);
    }
])->get();

Result:

Illuminate\Support\Collection: {
    #items: [
        0 => App\Models\Area {
            'id' => 1,
            'province_id' => 1
            '<alias>' => /* ... */
            'province' => App\Models\Province {
                'id' => 1
                'country_id' => 1,
                '<alias>' => /* ... */
                'country' => App\Models\Country {
                    'id' => 1
                    '<alias>' => /* ... */
                }
            }
        }
        /* ... */
    ]
}

Get be sure to pull in any Foreign Keys / Primary Keys that are used in the joins for the Eager Loading, or else the relationship will return an empty set.