Can I use 2 foreign keys with same primary key on same table
<p>I am building a mysql database with a table titled genre.</p>

<p>Users will be allowed to enter a main genre and a sub genre.</p>

<p>The genre database will be pre-populated with options provided by me. Example: 
HipHop
Country
R&amp;B
Latin
ect.</p>

<p>Both genre and sub-genre will be foreign keys pointing back to the genre table's primary key. My question is if this is a valid way of writing my table, or is there a better solution?</p>

<p>The tables look like this:</p>

<p><strong>USERS</strong></p>

<p>id|username|email</p>

<p><strong>GENRE</strong></p>

<p>id|genre</p>

<p><strong>USERS-GENRE</strong></p>

<p>id|userId|genreId|subgenreId</p>