$query->select(COUNT(*)) laravel code example

Example: laravel select count

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