通过好友关系表 获取我的好友

 

select a.* from yin_view_user_info a
inner join (
select   case userid  when 1 then FriendId else UserID END as FriendId from yin_friend_link_info
where userid=1 or friendid=1  ) friend_table on a.userid=FriendId