function party($id) {

$sql = "SELECT *
        FROM   `Вечеринки`
        WHERE `Club_id` = $id
        ORDER BY `Вечеринка`";
if ($result = mysql_query($sql)) {
  while ($row = mysql_fetch_assoc($result)) {
    echo $row["Вечеринка"];
  }
  mysql_free_result($result);
}

}

$sql = "SELECT *
        FROM   `Список клубов`
        ORDER BY `Название`";

if ($result = mysql_query($sql)) {
  while ($row = mysql_fetch_assoc($result)) {
    echo $row["Название"];
    party($row["Club_id"]);
  }
  mysql_free_result($result);
}