<?php
$usersql = "SELECT user.UserID,
user.UserName,
user.PhoneNumber,
user.IsAdmin,
user.DEID,
rider.RiderID,
user.CreatedAt AS UserCreatedAt,
user.UpdatedAt AS UserUpdatedAt,
user.CreatedDate AS UserCreatedDate,
rider.CreatedAt AS RaiderCreatedAt,
rider.UpdatedAt AS RaiderUpdatedAt
FROM user user
JOIN rider rider ON user.UserID=rider.UserID  
WHERE user.IsActive='1' AND rider.IsActive='1' $userSqlfilter";

$userRes = mysqli_query($conn, $usersql);
if ($userRes->num_rows > 0) {
  $id = 0;
  foreach ($userRes as $userrow) {
    $id++;
    $users = array_merge($users, array(array($id, $userrow['UserID'], $userrow['RiderID'], $userrow['DEID'], $userrow['UserName'], $userrow['PhoneNumber'], $userrow['UserCreatedAt'], $userrow['UserUpdatedAt'])));
  }
}


$userCountSql = "SELECT user.CreatedDate, count(user.UserID) AS ContData
from user user
WHERE user.IsActive='1' $userCountSqlfilter
GROUP BY user.CreatedDate";
$userCountRes = mysqli_query($conn, $userCountSql);
if ($userCountRes->num_rows > 0) {
  $id = 0;
  foreach ($userCountRes as $userCountrow) {
    $id++;
    $userCount = array_merge($userCount, array(array($id, $userCountrow['CreatedDate'], $userCountrow['ContData'])));
  }
}