SELECT * FROM(
SELECT *, @curRank := @curRank + 1 AS rank FROM
(SELECT CT u2.uuid as as uuid, d, u2.user_ner_name AS user_name, e, u2.fruits_num_num AS fruits_num from (`user` u LEFT JOIN friend f ON ON f.user_uer_uuid = = u.uuid)
LE)
LEFT JOIN `user` AS u2 ON ON f.friend_use_user_uuid = = u2.uuid whe where re u.uuid = ' = '223' ORDER BY fruits_num DESC) p
,(SELECT @curRank := 0) q
) s
WHERE uuid = '223'