One more note, my data is not normalized. I discovered the scenario below which causes and endless recursion. I can clean it up but just thought I would mention it.

declare @TV table (member varchar(255), relatedTo varchar(255))

insert into @TV

select 'John', 'Mary'union all

select 'Mary', 'Jessica' union all

select 'Jessica', 'Mary'