id firstname lastname    email         avatar
  1     Coman      Paul   x@y.com    ./images/a.png

id user1 user2
  1    1     2
  2    1     5
  3    3     1
  4    2     3

select u.firstname, u.lastname,u.email,u.avatar from users u
inner join friendships f on f.user2 = u.id
where f.user1 = 1
union
select u.firstname, u.lastname,u.email,u.avatar from users u
inner join friendships f on f.user1 = u.id
where f.user2 = 1

if($numrows!=0)
{

Echo '<div id="members">    <ul >';
while ($row = mysql_fetch_assoc($querym))
{


$firstname = $row['firstname'];
$lastname = $row['lastname'];
$email = $row['email'];
$avatar = $row['avatar'];

Echo '<li>......';
       //printing the variables and all data
     }

   }

select u.firstname, u.lastname,u.email,u.avatar from users u
where id not in (select user1 from friendships where user2 = 1)
and id not in (select user2 from friendships where user1 = 1)

and id <> 1