Consuta SQL para extraer los amigos de un miembro de una red social

[stone_neo]

No estoy muy seguro, pero intenta con esto :

Código:

SELECT s.id AS s__id, s.name AS s__name, s.edad AS s__edad, s.town AS s__town, 
       a.user1 AS a__user1, a.user2 AS a__user2, a.estado AS a__estado 
FROM usuario s, amigo_usuario a
WHERE a.estado = 1 and a.user1 = 1 and a.user1=s.id
UNION
SELECT s1.id AS s__id, s1.name AS s__name, s1.edad AS s__edad, s1.town AS s__town, 
       a1.user1 AS a__user1, a1.user2 AS a__user2, a1.estado AS a__estado 
FROM usuario s1, amigo_usuario a1
WHERE a1.estado = 1 and a1.user2 = 1 and a1.user2 = s1.id