Requête trop longue

$reponse = mysql_query("SELECT * FROM membres where up=\"$id\""); 
while ($donnees = mysql_fetch_array($reponse) ) { 
$ida=$donnees['id'];
$tot=$tot+2.7;

	$reponseb = mysql_query("SELECT * FROM membres where up=\"$ida\""); 
	while ($donneesb = mysql_fetch_array($reponseb) ) { 
	$idb=$donneesb['id'];
	$tot=$tot+1.8;
	
		$reponsec = mysql_query("SELECT * FROM membres where up=\"$idb\""); 
		while ($donneesc = mysql_fetch_array($reponsec) ) { 
		$idc=$donneesc['id'];
		$tot=$tot+0.9;
		
			$reponsed = mysql_query("SELECT * FROM membres where up=\"$idc\""); 
			while ($donneesd = mysql_fetch_array($reponsed) ) { 
			$idd=$donneesd['id'];
			$tot=$tot+0.9;
			
				$reponsee = mysql_query("SELECT * FROM membres where up=\"$idd\""); 
				while ($donneese = mysql_fetch_array($reponsee) ) { 
				$ide=$donneese['id'];
				$tot=$tot+0.9;
				
				}
			}
		}
	}

}