这个难到我了 我没有使用 in 和not in 的习惯 with temp as ( select distinct music_id from music_likes where user_id in ( select follower_id from follow where user_id = 1 ) and music_id not in ( select music_id from music_likes where user_id = 1 )) select music_name from temp a left join music b on a.music_id = b.id order by a.music_id asc