按与每个类别关联的会议数量排序类别

Question

Im getting all the categories like:

public function index(){
    return view('home')
        ->with('categories', Category::orderBy('created_at', 'desc')->get())
        ->with('conferences', Conference::orderBy('created_at','desc')->where('status','P')->take(8)->get())
}

Then in the blade file I show the categories like below. But do you know how to order the categories by the number of conferences associated with each category? That is, show first the categories that have more conferences associated with it. Do you know how that can be achieved?

<div class=" d-md-block">
    <div class="container">
        <div class="row">
            <div class="col p-0 m-0">
                <ul class="Categories__Menu">
                    @foreach($categories->take(6) as $category)
                        <li class="">
                            <a href="javascript:void(0)" name="category" id="{{$category->id}}">{{$category->name}}</a>
                        </li>
                    @endforeach
                    <li><a  data-toggle="modal" id="showCategories" data-target=".bd-example-modal-lg" href="">More <i class="fa fa-caret-down" aria-hidden="true"></i></a></li>
                </ul>
            </div>
        </div>
    </div>
</div>

Answer 1

Use this.

Category::withCount('conferences')->orderBy('conferences_count', 'desc')->get();