下面是我使用fluent query builder进行的查询.
$query = DB::table('category_issue')
->select('issues.*')
->where('category_id', '=', 1)
->join('issues', 'category_issue.issue_id', '=', 'issues.id')
->left_join('issue_subscriptions', 'issues.id', '=', 'issue_subscriptions.issue_id')
->group_by('issues.id')
->order_by(DB::raw('COUNT(issue_subscriptions.issue_id)'), 'desc')
->get();
正如你所看到的,我是按联接表中的计数排序的.这很好用.但是,我希望将此计数与我的 Select 一起返回.
我的原始查询很好.
Select issues.*, COUNT(issue_subscriptions.issue_id) AS followers
FROM category_issue JOIN Issues ON category_issue.issue_id = issues.id
LEFT JOIN issue_subscriptions ON issues.id = issue_subscriptions.issue_id
WHERE category_issue.category_id = 1
GROUP BY issues.id
ORDER BY followers DESC
我将如何使用Laravel的fluent query builder进行此 Select ?我知道我可以使用原始sql查询,但如果可能的话,我希望避免这种情况.任何帮助都将不胜感激,提前感谢!