PHP - Consulta SQL

$fIn = '2022-12-01';

$fFn = '2023-01-12';

$qA = "SELECT * from tabla1 where fecha between '" . $fIn . "' and '" . $fFn . "' group by id_persona";

$rA = $bd->query($qA);

while ($fA = $rA->fetch_array()) {

    $persona[] = $fA[1];

}

foreach ($persona as $id_persona) {

    $qB = "SELECT * from tabla1 where fecha between '" . $fIn . "' and '" . $fFn . "' and id_persona='" . $id_persona . "' order by fecha";

    $rB = $bd->query($qB);

    while ($fB = $rB->fetch_array()) {

        $a[] = $fB[2];

    }

    $b['persona' . $id_persona] = $a;

    $array[] = $b;

    unset($b);

    unset($a);

}

foreach ($array as $key => $value) {

    foreach ($value as $p => $value) {

        echo $p . ' : ';

        $i=count($array[$key][$p]);

        foreach ($array[$key][$p] as $value) {

            $i--;

            if($i==0) echo ' (ultimo) <b>'.$value.'</b>'; else echo $value . ',';

            $v[] = $value;

        }

        echo '<br>';

    }

    echo '-----------------------------<br>';

}

foreach (array_count_values($v) as $key => $value) {

    echo $key . ' -> ' . $value . ' veces<br>';

}

WITH ranked_contact AS (

  SELECT t1.*, ROW_NUMBER() OVER (PARTITION BY id_persona ORDER BY fecha DESC) AS rn

  FROM `tabla1` AS t1

)

SELECT contacto, count(*) as counter_contact from ranked_contact

where rn = 1 group by contacto;