从Laravel的相关表格中获得有限的结果

Question

表格

post            category
-----           ----------
id              id
name            name
category_id

每个职类的员额数量有限(如果职类有员额)

$categories = Category::get();
$categores_with_posts = array();

foreach($categories as $category)
{   
    $category_data = array(
        'posts' => Post::where('category_id', $category['id'])->take(10)->get()->toArray(),
        'category_id' => $category['id'],
        'name' => $category['name']
    );

    if(!empty($category_data['posts'])) {
        $categores_with_posts[] = $category_data;
    }
}

如何使用一个查询在Laravel中完成此操作？

Answer 1

这是经过测试的代码，但是您应该能够在这两个模型之间创建一个关系：

class Post extends Eloquent {

    public function category()
    {
        return $this->belongsTo('Category');
    }

}

class Category extends Eloquent {

    public function posts()
    {
        return $this->hasMany('Post');
    }

    public function postsTop10()
    {
        return $this->posts()->take(10);
    }

}

然后用它得到你的结果：

$categories = Category::with('postsTop10')->get();

foreach($categories as $category)
{   
    foreach($category->postsTop10 as $post)
    {
        echo "$post->name";
    }
}