Link two tables but limit results

Hello all,

Appreciate your advice as i've hit a wall now

Table 1 - user_awards

award_id

award_title

Table 2 - awards

user_id

(a column for each award_id) 0 = no, 1 = yes

I'd like to ideally create a result where it then displays all the records where the column in table 2 is 1 but I want to limit it to say 5 where the user_awards table = 1, however at present it counts five including entries where its 0.  This is where i'm getting unstuck so appreciate any advice.  Code snippet below.

  $awardCodes = mysql_query("SELECT * FROM `user_awards` WHERE `user_id` = 1"); 
  $awardsres = mysql_fetch_assoc($awardCodes);
  $awards = mysql_query("SELECT * FROM `awards` ORDER BY 'award_id' ASC LIMIT 4");  

  // Loop through award codes
  while ($ac2 = mysql_fetch_assoc($awards)) {  
  $ac22 = db_entry_check($awardsres[$ac2[award_id]])? 1 : 0; 
   
  if ($ac22 != $actual && $ac22 == 1) {
  
echo "$ac22[award_title]";

   }
   
   }

Sorry, I don't follow.