Php merge multiple query results into a single array.

See more:

PHP

MySQL

Hi I am trying to merge multiple MySQL query results into one single array. I am using

array_merge

function but I am getting null result. I am using the recursive function to fetch the data from the MySQL database . Here is my code.

  <?php

	$level=0;
	 $main_array[0]="";  		 // I want the results stored in this array.			

	function get_recursive_users($memberid,$level){
		
    
			$servername = "localhost";
			$username = "*****";
			$password = "*******";
			$dbName="*******"; 
         

				  $conn1 = new mysqli($servername,$username,$password,$dbName)or die("error 1");

				  $downlinks_query ="select MemberID from legcount where SponsorID='$memberid'"; 
				  $downlinks_res=mysqli_query($conn1,$downlinks_query) or die("error");
				  $level=$level+1;

				 
				  while(list($memberid)=mysqli_fetch_array($downlinks_res))
				  {
					 
					 
					  $downlinks_query123 ="SELECT d1.*, d2.`FullName` AS referral_name FROM detailsofuser d1, detailsofuser d2 WHERE d1.`IDSponsor` = d2.`MemberID` and d1.MemberID='$memberid'"; 
					 
					 $downlinks_res123=mysqli_query($conn1,$downlinks_query123) or die("error");
					  
					  $data = mysqli_fetch_array($downlinks_res123);  // This varibale gets the data from database correctly. 
					  
					   global $main_array;      
					  $main_array=array_merge($main_array, $data);
					  
						get_recursive_users($memberid,$level); 
					
    				
				  }  

	}  


   	 get_recursive_users($memberID,$level);
   var_dump($main_array);
?>

What I have tried:

The output is

Quote:

array(1) { [0]=> string(0) "" }

I have got only the value I have inserted manually. Please help me append all the data in

main_array

variable.