排名无平局获胜 - wins ranking no tie

我有一个问题，每个用户的排名都是完美的，问题是当用户"a"的结果与用户"b"的相同时

我的代码

  SELECT ID, Wins, 
    (SELECT COUNT(*)+1 FROM users WHERE Wins>x.Wins) AS rank_upper, 
    (SELECT COUNT(*) FROM users WHERE Wins>=x.Wins) AS rank_lower 
 FROM `users` x WHERE x.username='$_GET[user]'
ID   wins Rank
 1    23    1
 2    17    2
 3    17    2
 4    10    3
 5    10    3

我喜欢这样：

 ID   wins Rank
 1    23    1
 2    17    2
 3    17    3
 4    10    4
 5    10    5

比较id可能也适用于

SELECT ID, Wins, 
    (SELECT COUNT(*)+1 FROM users WHERE Wins>x.Wins or (Wins=x.Wins and id<x.id)) AS Rank 
 FROM `users` x WHERE x.username='$_GET[user]'