使用 RAND 在 ORDER BY 子句的结果是，用户将被随机排序，而不考虑其 status .
您必须在子查询中选择10个随机记录，然后在按顺序排序的外部查询中使用此集合 status 根据需要：

SELECT users_id, name, users_age
FROM 
(
   SELECT users_id, concat(users_fname, ' ', users_lname) as name,
          IFNULL(users.users_age, '') as users_age 
   FROM `users` 
   ORDER BY RAND() LIMIT 10
) AS t
ORDER BY status DESC, 
         CASE 
            WHEN status = 1 THEN name 
            ELSE 1
         END ASC

希望对你有帮助

ORDER BY status DESC, (CASE WHEN status = '1' THEN 1 ELSE 0 END),name ASC

这是整个查询

SELECT users_id, concat(users_fname, ' ', users_lname) as name,
 IFNULL(users.users_age, '') as users_age 
 FROM `users` ORDER BY status DESC, (CASE WHEN status = '1' THEN 1 ELSE 0 END),name ASC LIMIT 10