无法正确形成MySQL查询（或子查询）

I have an SQL query that I just can't seem to get right. The table isn't terribly complicated. The fields I have are Name and 2 FacebookUserIDs. I am having a referral contest. The first FbookUId is the ID of the person who entered the contest, and the referral ID is the ID of the user who referred them. I want to select each of the primary fbookUIDs and count the number of referrals that person is responsible for. Here is the query I've tried:I have an SQL query that I just can't seem to g