好友表的问题

id   f_to   f_from   status
1     mike   jener    0
2     mike   jay      1
3     patric  mike    1
4     mike    lucy    1    

select f_to from  table1 where f_from='mike' and status=1
union 
Select f_from from table1   where f_to='mike' and  status=1