How to make sorting sort on related table?

Question

Laravel

Now sorting by table id Question

$ArrQuest = Question::with('user', 'file', 'answer')->orderBy('id','desc')->paginate(15);

Is it possible to sort by the number of rows in the linked table? answer
I looked everywhere and did not find a single working solution.

Answer 1

Something like this.
I threw an idea, I hope you figure it out yourself. Didn't test.

$Question = new Question;
$ArrQuest = Question::with('user', 'file', 'answer');

$Relation = $Question-> answer();
$Table = $Question->getRelated()->getTable();

$ArrQuest = $ArrQuest->join($Table, $Relation->getQualifiedForeignKey(), '=', $Relation->getQualifiedOtherKeyName())->orderBy(DB::raw("count(`{$Table}`.`id`)"), 'asc')->paginate(15);