How to take several arrays with 1 single index and put in a single array?

Question

I’m 3 days trying to solve a problem, I can’t get multiple arrays with 1 single input and put and a single array.

EX:
Está imprimindo assim:
Array(
      [0]=> "MT"
     )
Array(
      [0]=> "MG"
     )
Array(
      [0]=> "AM"
     )

Quero fazer assim:

Array([0]=>"MT", [1]=>"MT", [2]=>"MT")


//MEU BANCO DE DADOS CONSIDERANDO APENAS AS PESSOAS DA REDE DO ID 1001

id_usuario |  uf
-------------------------
1001          |  SP
1003          | MG
1005          | AM
1027          | MT

// MONTAGEM DA REDE

                 1001
                /    \
             1003     1005
              /
           1027

My code:

<?php 
function buscarEstados1($id){
    include 'includes/conexao.php'; 

    $s_down = "select id from tab_afiliado where upline = $id";
    $res_down = $cnns->query($s_down);
    foreach ($res_down as $down){
        $aff_uf = $down['id'];//var_dump($aff_uf); //PEGA OS IDS 1003, 1027, 1005

        $s_uf = "select uf,id_endereco from tab_endereco WHERE id_endereco = " . $aff_uf . "";
        $res_uf = $cnns->query($s_uf);
        foreach ($res_uf as $uf){
            $arr = $uf['uf']; //var_dump($arr); //PEGA AS UF MG , AM , MT 
        }

        buscarEstados1($aff_uf);
    }
}

    buscarEstados1(1001);
?> 

I would like to take the Ufs and make an array only Array ( "MG" , "AM" , "MT");

The problem is as if the loop caught like this.

 print_r(#arr);

    $arr = array( "MG" );
    $arr = array( "MT" ); 
    $arr = array( "AM" );

Answer 1

Create two functions to facilitate logic, one to search for all affiliates and the other to search for their status.

function buscarAfiliados($id){
    include 'includes/conexao.php'; 

    $s_down = "select id from tab_afiliado where upline = $id";
    $res_down = $cnns->query($s_down);
    foreach ($res_down as $down){
     $aff_uf = $down['id'];

     return $cnns->query($s_uf);
    } 
}

function buscarEstados($id){
    include 'includes/conexao.php'; 
    $s_uf = "select uf,id_endereco from tab_endereco WHERE id_endereco = " . $id . "";
    $res_uf = $cnns->query($s_uf);
    foreach ($res_uf as $uf){
        $arr[] = $uf['uf']; 
    }
    return $arr;
}

    $afiliados = buscarAfiliados(1001);

    foreach($afiliados as $item){
        $estados[] =buscarEstados($item['uf'])
    }

Answer 2

I wouldn’t do it like this, but giving you an alternative would be :

<?php 
function buscarEstados1($id, &$arr = array()){
    include 'includes/conexao.php'; 

    $s_down = "select id from tab_afiliado where upline = $id";
    $res_down = $cnns->query($s_down);
    foreach ($res_down as $down){
        $aff_uf = $down['id'];//var_dump($aff_uf); //PEGA OS IDS 1003, 1027, 1005

        $s_uf = "select uf,id_endereco from tab_endereco WHERE id_endereco = " . $aff_uf . "";
        $res_uf = $cnns->query($s_uf);
        foreach ($res_uf as $uf){
            $arr[] = $uf['uf']; //var_dump($arr); //PEGA AS UF MG , AM , MT 
        }

        buscarEstados1($aff_uf, $arr);
    }
}

    $ufs = array();
    buscarEstados1(1001, $ufs);

    print_r($ufs); // Seu Resultado
?> 

Answer 3

Loop by taking the values of the multidimensional array and throwing them into a simple array.

In the example below override the original array itself:

$arr = array(array('a'), array('b'), array('c'));

foreach ($arr as $k => $v)
    $arr[$k] = $v[0];

print_r($arr);

If you want to modify the structure of the SQL query, using JOIN, see example below

    <?php 
    function buscarEstados1($id){
        include 'includes/conexao.php'; 


        $sql = "select 
        T1.id AS id,
        T3.id AS afiliado_id,
        T2.uf AS uf, 
        T2.id_endereco AS id_endereco
        from tab_afiliado AS T1
        LEFT JOIN tab_afiliado AS T3 ON T3.upline = T1.id
        LEFT JOIN tab_endereco AS T2 ON T2.id_endereco = T1.id"
        where upline = $id";

        $rs = $cnns->query($sql);

        print_r($rs); exit;

/**
O restante do código omiti pois não entendi porque está fazendo recursividade.
*/
    }