[求助] 关于 mysql 子查询和 IN 的问题

[kukala]

```
... IN (SELECT `id` FROM `member` WHERE `friendsid` = ( SELECT `id` FROM `member` WHERE `id` = '1' ))...
```

这样的语句，出来的结果是 IN(2,3,4)
怎么把子查询最里面的 ID 为 1 的也添加到 IN 查询里去
比如 IN(1,2,3,4)这样

[0x663]

IN (1,SELECT `id` FROM `member` WHERE `friendsid` = ( SELECT `id` FROM `member` WHERE `id` = '1' ))

[0x663]

上边是开玩笑的
```sql
IN (1,SELECT `id` FROM `member` WHERE `friendsid` = (
SELECT `id` FROM `member` WHERE `id` = '1' )
union
select 1 as id
)
```

[kukala]

@liushaokang 感谢回复！原来用 union 就行了