Get all details from three tables

You can keep chaining here

$subcribers = Subscriber::with('subscriber.profile')
            ->where('active', '=', '1')
            ->where('digital', '=', '1')
            ->get();

Now you can access the profile as well

foreach($subcribers as $subscriber) {
    echo $subscriber->subscriber->profile->name;
}

@bobbybouwmann Thank you. I was just looking at eager loading. is it possible to do it like user with profile, subscription(where active=1 and digital=1)

You mean you go the other way? From user to subscriber?

User::with(['profile', 'profile.subcribers' => function($query) {
    $query->where('active', '=' ,1)
        ->where('digital', '=', 1)
})]->get();

yes. but i got this. Call to undefined method Illuminate\Database\Query\Builder::subcribers()

can you explain profile.subcribers ?

My mistake! It's subscription instead of subscriber!

User::with(['profile', 'subscription' => function($query) {
    $query->where('active', '=' ,1)
        ->where('digital', '=', 1)
})]->get();

I thought the relation was setup different, but the dot notation means you can chain into relations

Example: http://laravel-tricks.com/tricks/chaining-eager-loading

thanks for explaining. but this setup pulls every rows from user table with its relation. condition is not checked.

Aah oke, so you only want the users ;) Then you need to look at whereHas

User::with(['profile', 'subscription']->whereHas('subscription', function($query) {
    $query->where('active', '=' ,1)
        ->where('digital', '=', 1)
})->get();

Source: http://laravel.com/docs/5.1/eloquent-relationships#querying-relations

i am trying to understand how this works. can you explain why this pulled all records without meeting condition

User::with(['profile', 'subscription' => function($query) {
    $query->where('active', '=' ,1)
        ->where('digital', '=', 1)
})]->get();

Well it pulls all users with their profile and their subscription. Only the subscriptions are sorted right now! If you only want to users with that you can use whereHas

$usersWithDigitalSubscription = User::whereHas('subscription', function($query) {
    $query->where('active', '=' ,1)->where('digital', '=', 1);
})->get();

User::with(['profile', 'subscription' => function($query) {
    $query->where('active', '=' ,1)
        ->where('digital', '=', 1)
})]->get();

this will work if the profile and subscription are related? if no then when will the condition kicks in