Problem with alphabetical ordering in laravel?

0

I have a query in laravel that lists me all the users that exist I want to sort alphabetically but the way I put it through the laravel documentation and how I have done does not order does nothing

PHP

private function getChilds(array $elements, $parentId = 0) {

    $branch = array();

    foreach ($elements as $element) {
        if ($element['parent'] == $parentId) {
            $children = $this->getChilds($elements, $element['id']);
            if ($children) {
                foreach ($children as $child){
                    $branch[] = $child;
                }
            }
            $branch[] = $element;
        }
    }

    return $branch;
}

public function lista_jogadores (){

    $user_id = Auth::user()->id;

    $players = DB::table('players')->where('activo', '=', '1')->where('agent', '=', $user_id)->get();

    $childs = DB::table('agents')->select('id', 'username', 'parent')->orderBy('username', 'ASC')->get();
    $childs_arr = array();
    foreach ($childs as $child){
        $child_arr = array(
            'id' => $child->id,
            'username' => $child->username,
            'parent' => $child->parent
        );
        $childs_arr[] = $child_arr;
    }
    $parents = $this->getChilds($childs_arr, $user_id);

    return view('admin.templates.jogadores', ['players' => $players])->with('parents',$parents);

} 
    
asked by anonymous 02.05.2017 / 18:18

0 answers