暫時想到的是設(shè)計兩張表

user 表（用戶表）

id   user
1    張三
2    李四
3    王五
4    趙六

friend 表（會員關(guān)系表）

id   uid   fid
 1    1     2
 2    1     3
 3    2     1
 4    4     2
 5    4     3

如果要查找好友

 select * from friend where uid='張三' or fid='張三'

查找好友數(shù)最多的前三個人

select * from user a,friend b where a.id = b.uid
   and a.id  in(
                select uid count(*) AS cn
                FROM friend GROUP BY
                uid ORDER BY cn      
                desc LIMIT 3 
 ) 

好像不對，請高手指教。。。