BuddyPress.org

Yeah, I amended my previous post after I typed it because I noticed the query would not work.
You’ll have to join the same table, then you could get the result you need.

Do a search on Google on self joins for more info.