2 queries til 1

Hejsa,

Hvordan laver jeg disse to queries til to?

// Movie query
$movie_query = mysql_query("SELECT mid,title,category FROM movies WHERE approved_by='' ORDER BY date_added DESC ") or die (mysql_error());
while($movie_fetch = mysql_fetch_array($movie_query)) {

  // Variables
  $movie_mid = $movie_fetch[mid];
  $movie_title = $movie_fetch[title];
  $movie_category = $movie_fetch[category];
   
  // Category query
  $category_query = mysql_query("SELECT name FROM categories WHERE id='$movie_category' LIMIT 1 ") or die (mysql_error());
  $category_fetch = mysql_fetch_array($category_query);
  $movie_category = $category_fetch[name];