$sql = "SELECT a.*, b.user_id, b.imageurl
FROM cms_users a LEFT JOIN cms_user_profiles b ON a.id=b.user_id ORDER BY {$order} DESC
LIMIT ".$cfg['limit'];
ЗАМЕНИТЕ НА:
$sql = "SELECT a.*, b.user_id, b.imageurl
FROM cms_users a LEFT JOIN cms_user_profiles b ON a.id=b.user_id WHERE a.is_deleted=0 ORDER BY {$order} DESC
LIMIT ".$cfg['limit'];