I have a table `Follow`, which only holds records of which `UserID` follows which `TargetID`. 

If asked for user A:

* If neither A or B are following eachother, they have status of `0` for **unrelated**, and aren't included in the results.
* If user A is following B but not vice versa, B has status `1` for
being **followed**.
* If user B is following A but not vice versa, B has
status `2` for being a **follower**.
* If A is following B, and B following
A, B has status of `3` for being a **friend**.

How can I, in a single MySQL query, get the relationship status for a given user and all its relationships above status 0?

Example:

```
Users:
+----+-------+
| id | Name  |
+----+-------+
|  1 | Bob   | 
|  2 | Steve |
|  3 | Scott | 
|  4 | Mary  | 
+----+-------+

Follow:
+----+--------+----------+
| id | UserID | TargetID |
+----+--------+----------+
|  1 |      1 |        2 |
|  2 |      1 |        3 |
|  3 |      2 |        1 |
|  4 |      4 |        1 |
+----+--------+----------+

Expected result for user 1:
+----------+--------+-------+
| TargetID | Status | Name  |
+----------+--------+-------+
|        2 |      3 | Steve | (friend)
|        3 |      1 | Scott | (following)
|        4 |      2 |  Mary | (follower)
+----------+--------+-------+

```