DB::table('table')
 ->select(DB::raw('DATE(login_date) as date'), DB::raw('count(*) as total'))
 ->groupBy('date')
 ->get();