MySQL - 每个WHERE_IN问题的棘手限制

I am looking to do the following (see pseudo code); I want to select 4 rows for each gd.id (7, 11 or 9). I've incorrectly use limit because that only brings up 4 rows in total. Anyone have an idea on how to change this query to accomplish my goal? I am looking to do the following (see pseudo co