วิธี JOIN 2 ตารางและนับจำนวนที่ตารางแรก???

CREATE TABLE IF NOT EXISTS `rdb_users` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_login` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'username (must be unique for use as login)',
  `user_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'email (must be unique for use as login)',
  `user_password` text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'password',
  `user_display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'display name for cloak the username',
  `user_create` datetime DEFAULT NULL COMMENT 'user created date/time',
  `user_create_gmt` datetime DEFAULT NULL COMMENT 'user created date/time in gmt 0',
  `user_lastupdate` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'user last update',
  `user_lastupdate_gmt` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'user last update in gmt 0',
  `user_lastlogin` datetime DEFAULT NULL COMMENT 'user last login',
  `user_lastlogin_gmt` datetime DEFAULT NULL COMMENT 'user last login in gmt 0',
  `user_status` int(1) NOT NULL DEFAULT 0 COMMENT 'user status. 0=disabled, 1=enabled',
  `user_statustext` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'user status text for describe what happens. (untranslated.)',
  `user_deleted` int(1) NOT NULL DEFAULT 0 COMMENT 'user soft deleted. 0=not deleted, 1=deleted',
  `user_deleted_since` datetime DEFAULT NULL COMMENT 'user deleted since date/time',
  `user_deleted_since_gmt` datetime DEFAULT NULL COMMENT 'user deleted since date/time in gmt 0',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_login` (`user_login`),
  UNIQUE KEY `user_email` (`user_email`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='contain users account' AUTO_INCREMENT=142 ;

CREATE TABLE IF NOT EXISTS `rdb_users_roles` (
  `usersroles_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT 'refer to users.user_id',
  `userrole_id` bigint(20) NOT NULL COMMENT 'refer to user_roles.userrole_id',
  PRIMARY KEY (`usersroles_id`),
  KEY `user_id` (`user_id`),
  KEY `userrole_id` (`userrole_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='contain user''s roles relation' AUTO_INCREMENT=70 ;

SELECT 
  COUNT(`users`.`user_id`) AS `total`

FROM `rdb_users` AS `users`

LEFT JOIN `rdb_users_roles` AS `users_roles`
  ON `users_roles`.`user_id` = `users`.`user_id`

WHERE 1
  AND `user_deleted` = 0

SELECT 
  COUNT(`users`.`user_id`) AS `total`

FROM `rdb_users` AS `users`

LEFT JOIN `rdb_users_roles` AS `users_roles`
  ON `users_roles`.`user_id` = `users`.`user_id`

WHERE 1
  AND `user_deleted` = 0
  AND `users_roles`.`userrole_id` = 3