DB::raw('count(*) as id, where code example

Example: laravel select count

$count = DB::table('category_issue')->count();