怎么在一张朋友表里面查询和自己有相同朋友并且不是自己的朋友的用户

Question

uid和朋友ID都是在另外一张表里面
怎么在一张朋友表里面查询和自己有相同朋友并且不是自己的朋友的用户

Answer 1

+-----------+-----+------------+
| friend_id | uid | friend_uid |
+-----------+-----+------------+
|         1 |   1 |        143 |
|         2 |   1 |        144 |
|         3 |   1 |        145 |
|         4 | 143 |        145 |
|         5 | 144 |          2 |
|        17 |   1 |          5 |
|         7 |   2 |          3 |
|         8 |   3 |        143 |
|         9 | 144 |          1 |
|        10 | 143 |          1 |
|        11 | 122 |        143 |
|        12 | 145 |        143 |
|        13 |   2 |        144 |
|        14 | 143 |        122 |
|        15 |   3 |          2 |
|        16 | 143 |          3 |
|        18 |   5 |          1 |
|        19 |   2 |          5 |
|        20 |   5 |          2 |
+-----------+-----+------------+这是表