mysql concat 条件_MySQL GROUP_CONCAT中的条件

我有一个MySQL表与请求

+--------+-------------+-----+

| req_id | req_name | ... |

+--------+-------------+-----+

| 1 | testrequest | ... |

+--------+-------------+-----+和一张表格就这些请求进行投票。

+--------+-----------+----------+

| req_id | vote_name | approved |

+--------+-----------+----------+

| 1 | User1 | 1 |

| 1 | User2 | 1 |

| 1 | User3 | 1 |

| 1 | User4 | 0 |

| 1 | User5 | 0 |

+--------+-----------+----------+我想要的那种观点：

+--------+-------------+---------------------+--------------+

| req_id | req_name | approved_by | rejected_by |

+--------+-------------+---------------------+--------------+

| 1 | testrequest | User1, User2, User3 | User4, User5 |

+--------+-------------+---------------------+--------------+但是到目前为止，我只能做到这一点：

+--------+-------------+----------+---------------------+

| req_id | req_name | approved | by |

+--------+-------------+----------+---------------------+

| 1 | testrequest | YES | User1, User2, User3 |

| 1 | testrequest | NO | User4, User5 |

+--------+-------------+----------+---------------------+我使用的查询：

SELECT requests.req_id, req_name, CASE

WHEN approved THEN 'YES'

ELSE 'NO'

END AS approved, GROUP_CONCAT(vote_name ORDER BY vote_name ASC SEPARATOR ', ') AS by

FROM requests

LEFT JOIN votes ON requests.req_id = votes.req_id

GROUP BY requests.req_id, approved

ORDER BY requests.req_id DESC;所以我的问题是，如何在同一行中获得2个不同值的group_concats？

非常感谢！