this is my php code

				<?php
$con=mysqli_connect("localhost","root","admin321","data");

				if (mysqli_connect_errno())
				  {
				  echo "Failed to connect to MySQL: " . mysqli_connect_error();
				  }

				 $sql="SELECT * FROM phptab where value LIKE '%அகடம்%'";
				$r = mysqli_query($con,$sql);
						$data = array();

						while($row = mysqli_fetch_assoc($r)) {

						  $data[] = $row;
						}
	function buildtree($src_arr, $parent_id = 0, $tree = array())
				{
					foreach($src_arr as $idx => $row)
					{
						if($row['parent'] == $parent_id)
						{
							foreach($row as $k => $v)
								$tree[$row['id']][$k] = $v;
							unset($src_arr[$idx]);
							$tree[$row['id']]['children'] = buildtree($src_arr, $row['id']);
						}
					}
					ksort($tree);
					return $tree;
				}

				function insertIntoNestedArray(&$array, $searchItem){

					if($searchItem['parent'] == 0){
						array_push($array, $searchItem);
						return;
					}
					if(empty($array)){ return; }
				 array_walk($array, function(&$item, $key, $searchItem){
					if($item['id'] == $searchItem['parent']){
							array_push($item['children'], $searchItem);
							return;
						}
						insertIntoNestedArray($item['children'], $searchItem);
				}, $searchItem);
				}
				$nestedArray = array();
				foreach($data as $itemData){
				 $nestedArrayItem['id'] = $itemData['id'];
					$nestedArrayItem['name'] = $itemData['name'];
					$nestedArrayItem['parent'] = $itemData['parent'];
			 $nestedArrayItem['color'] = $itemData['color'];
			$nestedArrayItem['children'] = array();
				insertIntoNestedArray($nestedArray, $nestedArrayItem);
				}
				header('Content-Type: application/json');
print_r($nestedArray);
			?>

OUTPUT FOR THE ABOVE CODE IS THIS

				Array
(
    [0] => Array
        (
            [id] => 44
            [name] => அகடம்
            [parent] =>
            [color] => red
            [children] => Array
                (
                    [0] => Array
                        (
                            [id] => 45
                            [name] => மோசடி
                            [parent] => 44
                            [color] => red
                            [children] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [id] => 46
                            [name] => சூழ்ச்சி
                            [parent] => 44
                            [color] => red
                            [children] => Array
                                (
                                )

                        )

                    [2] => Array
                        (
                            [id] => 47
                            [name] => அநீதி
                            [parent] => 44
                            [color] => red
                            [children] => Array
                                (
                                )

                        )

                    [3] => Array
                        (
                            [id] => 48
                            [name] => பொல்லாங்கு
                            [parent] => 44
                            [color] => red
                            [children] => Array
                                (
                                )

                        )

                )

        )

)



EXPECTED OUPUT

                	Array
(
    [0] => Array
        (
            [id] => 44
            [name] => அகடம்
            [parent] =>
            [color] => red
            [children] => Array
                (
                    [0] => Array
                        (
                            [id] => 45
                            [name] => மோசடி
                            [parent] => 44
                            [color] => red


                        )

                    [1] => Array
                        (
                            [id] => 46
                            [name] => சூழ்ச்சி
                            [parent] => 44
                            [color] => red


                        )

                    [2] => Array
                        (
                            [id] => 47
                            [name] => அநீதி
                            [parent] => 44
                            [color] => red


                        )

                    [3] => Array
                        (
                            [id] => 48
                            [name] => பொல்லாங்கு
                            [parent] => 44
                            [color] => red


                        )

                )

        )

)

DIGGERENCE IN THE EXPECTED OUPUT AND ORIGINAL OUPUT -
 REMOVED EMPTY VALUE FROM THE ARRAY
 [children] => Array
                                (
                                )
)