MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table rider_status (rider_userId int, created_date date)
create table rider_user (id int, isActive int, online_status int)
SELECT * 
FROM (SELECT * 
      FROM rider_status 
      order by created_date DESC) as riderActice 
INNER JOIN rider_user ON rider_userId = rider_user.id 
Where rider_user.isActive = 1 
AND online_status = 1 
GROUP by rider_userId

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'riderActice.created_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


SELECT * 
FROM (SELECT * 
      FROM rider_status 
      order by created_date DESC) as riderActice 
INNER JOIN rider_user ON riderActice.rider_userId = rider_user.id 
Where rider_user.isActive = 1 
AND rider_user.online_status = 1 
GROUP by riderActice.rider_userId
         , riderActice.created_date
         , rider_user.id
         , rider_user.isActive
         , rider_user.online_status


rider_userId
created_date
id
isActive
online_status