users
-----
id (PK)
name
email

connections
-----------
user_id
friend_id

SELECT * FROM ci_users AS u
LEFT JOIN connections AS c ON u.id = c.user_id
LEFT JOIN users AS new on c.friend_id = u.id
WHERE u.id=3