how to insert limited number record for each user?

I have video website. I want to limit the user so each user can publish 10 posts.

I try to search the insertion queries by which I can limit this insertion for every user.

I want that each user can publish only 10 posts.

via Chebli Mohamed