Question: I have a mysql table consisting of users following other users. 

```
USER_ID FOLLOW_ID
1        2
1        3
2        4
3        4
6        4
2        6

```

I am user No. 2 and the person in question is user No. 4. You see that three people are following user No.4 including me. I can query the users who are following user No.4. How can I add to the query if I am following these people or not? So what I would like to know is who are following a specific user (No.4 in this case) and which one of them I am following.

Desired result:

```
USER_ID (No.4 is FOLLOWED BY), DO_I_FOLLOW_HIM
2                              No
3                              No
6                              Yes

```

As you see from the last record of the table I (No.2) am following User No.6.

Query the list of people following user No.4:

```
$myid = '6';
$userid = '4';
    $i = 0;
    try {
        $stmt = $conn->prepare("SELECT USER_ID FROM FOLLOW WHERE FOLLOW_ID=?");

        $stmt -> execute(array($userid));
            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
                $row2[$i] = $row['USER_ID'];
                $i++;               
            }
        } catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
        $response["success"] = 0;
    }

```

Sample SQL Fiddle for help: <http://sqlfiddle.com/#!2/97ac6>

Answer: 
```
SELECT him.user_id, IF(i.follow_id,'yes','no') AS i_follow_him
FROM Follows him
LEFT JOIN Follows i ON (i.follow_id = him.user_id AND i.user_id = 2)
WHERE him.follow_id = 4

```
I made it easier by adding your own id and user No 4.

```
select follow_id
from follows
where user_id=2 and follow_id IN (select user_id from follows where follow_id=4)

```