SET @amount=0;

  SET @rank=1;

  SET @shunxu=0;

 SELECT tmp2.id AS id,tmp2.name AS NAME,tmp2.amount AS amount,tmp2.rank  AS rank

 FROM (

 SELECT tmp.id AS id,tmp.name AS NAME,tmp.amount AS amount,@shunxu:=@shunxu+1,IF(amount=@amount,@rank,@rank:=@shunxu) AS rank,@amount:=amount

 FROM(

 SELECT  `ti`.`user_id` AS `id`, 

 (SELECT  `tu`.`name`  FROM `t_users` `tu`  WHERE (`tu`.`id` = `ti`.`user_id`)) AS `name`, 

 SUM(`ti`.`amount`) AS `amount` FROM `t_invests` `ti`

 GROUP BY `ti`.`user_id`

 ORDER BY SUM(`ti`.`amount`)DESC) tmp)tmp2