选择限制，但也限制列可以具有特定值的次数

I've got the following SQL query. I want to get 5 posts from this query, but I also want to limit it so that I can, at most, get two posts per user. Only two users in this case, would mean a maximum of four posts.I've got the following SQL query. I want to get