“更好”的方法用于匹配MySQL语句中的ID集

I'm currently running some SQL which uses an IN expression to match against multiple IDs. However, I would ideally like to be able to match up certain IDs with others so they must appear together to return a result. Here's an example:I'm currently running some SQL which uses an IN