Order by not working with left Join Laravel

Here is my code. I want want latest image path for each user id. Please help me

public function getCompleteUserDetailsById($id) {
    $results = \DB::table("users")
            ->join('cities', 'cities.id', '=', 'users.city_id')
            ->leftJoin('attachments', function($join) {
                $join->on('users.id', '=', 'attachments.parent_id');
                $join->where('attachments.status', '=', 1);
                $join->where('attachments.type_id', '=', 1);
            })
            ->where('users.status', '=', 1)
            ->where('users.id', '=', $id)
            ->select(
                    DB::raw('CONCAT(attachments.path, "/", attachments.file_hash) AS user_img'), 'users.id as user_id', 'users.gender as gender', 'users.fname as fname', 'users.lname as lname', 'users.uname as uname', 'users.email as email', 'users.address as address', 'users.city_id as city_id', 'users.website as website', 'cities.title as city_title'
            )                
            ->groupBy('users.id')
            ->orderBy('attachments.id', 'desc')
            ->first();
    return $results;
}

via Chebli Mohamed