How to query only one foreign row in a one-to-many relationship in Laravel 5

I have 4 models: posts, users, categories, userCategories.

posts-users have one-to-many relationship (one post belongs to a user).

posts-categories have one-to-many relationship (one post belongs to a category).

users-userCategories have one-to-many relationship (one user has many userCategories). userCategory has a rank field which holds the performance of the user for the specific category.

I query some posts with this:

$posts = Post::with(array('user.userCategories')
                )
            ->where('category_id', '=', $category_id)
            ->get();

After evaluating posts, I try to get the user's the userCategory rank for the post's category.

$rank_of_the_post_owners = array();
foreach($posts as $post)
    foreach($post->user->userCatergories as $userCategory)
        if($userCategory->id == $post->category_id) {
            $rank_of_the_post_owners [$post->id] = $userCategory->rank;
            break;
        }
    }
}

To get rid of the code above, I want to query only related userCategory (for the post's category). So that, I want to access the rank information like user.userCategory instead of the loop.

How can I do that?

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2uqF5to
via IFTTT