ผมต้องการจะ select ข้อมูลจาก2ตารางแล้วเอามาwhile loop โดยให้แสดงแสดงข้อมูลให้หมดจากตารางแรกอะครับ

<?php 
   // File Index.php
   $conn = mysqli_connect("localhost", "root", " adminadmin");
   mysqli_set_charset($conn,'utf8');
   $set = "USE mydatabase";
   $query = mysqli_query($conn,$set);
   $select = "SELECT * FROM project2 WHERE namepro, budget";
   $query = mysqli_query($conn,$select);
   while ($array = mysqli_fetch_array($query))
   { $budget = "$array[budget]"; $namepro = $array[namepro]"; }
   $select = "SELECT * FROM donate WHERE money";
   $query = mysqli_query($conn, $select);
   while ($array = mysqli_fetch_array($query))
   { $money = "$array[money]"; }
   // นำค่ามารวมกัน 
   $resultMoney = "$budget + $money";
   $name = "$namepro";
   $result = "โดย <b>$name</b> <br>มูลค่า :<b> $resultMoney</b>";
   // โชว์รายชื่อ
   while ($result = "$result"))
   { echo "$result"; }
   mysqli_close($conn);
?>

<?php
	$con = mysqli_connect("localhost", "root", "");
	mysql_select_db("mydatabase2");
	mysql_query("set NAMES utf8");	
	$select = mysql_query"SELECT project2.namepro,project2.budget,(select sum(donate.money) from donate where project2.namepro = donate.namepro)as tomoney, 
	project2.budget-tomoney as moredo from project2 inner join donate on project2.namepro=donate.namepro";
	
	while($row = mysql_fetch_array($select)){
		echo "<tr>";
		echo "<td>".$row['namepro'];
		echo "<td>".$row['budget'];
		echo "<td>".$select.tomoney;
		echo "<td>".$select.moredo;
		echo "<tr>";
	}
?>