SELECT
    COUNT(db.id) as count,
    db.uye_id
FROM
    db
GROUP BY
    db.uye_id
ORDER BY
    count DESC
Veriler order by desc komutuyla zaten büyükten küçüğe doğru gelecek.