Get last 7 days data from database order by relation table's field

get-last-7days-data.php

<?php

    public function test(){
        $days = new Carbon();
        $bn_contents = BnContent::with('category','subcategory','content_meta')
            ->leftJoin('bn_content_metas', 'bn_contents.content_id', '=', 'bn_content_metas.content_id')
            ->where('bn_contents.created_at', '<', $days->subDays(7)->toDateTimeString())
            ->where('bn_contents.status', 1)->where('bn_contents.deletable', 1)
            ->orderBy('bn_content_metas.total_hit','desc')->take(5)->get();
        return ($bn_contents);
    }