如何从mysql查询中获取关注者/以下列表

你可以use separate queries:

要获得粉丝:

SELECT GROUP_CONCAT(DISTINCT t1.follower_id) as followers FROM test_f t1 WHERE t1.user_id = 6

要获得以下内容:

SELECT GROUP_CONCAT(DISTINCT t2.user_id) as following FROM test_f t2 WHERE t2.follower_id = 6