[russian] Юзеры – Друзья. Какая связь? / Проектирование БД : Форум на SQL.RU || User – Friends relationship : Database design, forum SQL.ru
design pattern for friends/users, i.e. how to organize user-friend relationship. patters suggest that you need to make 2 tables, i.e freindship and friendship:user