问多维数组处理SQL结果

EN

$sql = "SELECT DISTINCT person_id, person_name
       FROM companyperson
       INNER JOIN person
       ON personid = person_id
       WHERE companyid = '$company_id' ";

while ($row = mysqli_fetch_array($result))
{
     $employee_people[] = array('person_id' => $row['person_id'], 'person_name' => $row['person_name']);
}

foreach($employee_people as $employee_person)
{
     $person_id = $employee_person['person_id'];

     $sql = "SELECT duty
            FROM companyperson
            INNER JOIN person
            ON personid = person_id
            WHERE companyid = '$company_id'
            AND person_id = '$person_id' ";

     $employee_duties = array();

     while ($row = mysqli_fetch_array($result))
     {
          $employee_duties[] = array('duty' => $row[duty']);
     }
     $employee_person_duties[] = array($employee_duties, 'person_name' => $employee_person['person_name'], 'person_id' => $employee_ person['person_last_name']);
}

<?php foreach ($employee_person_duties as $employee_person_duty): ?>
<a href = "/person/<?php htmlout($employee_person_duty ['person_url']); ?>">
<?php htmlout($employee_person_duty ['person_name']); ?></a>
.....
<?php $duties_array = array(); foreach ($employee_duties as $employee_duty)
{   
     $duties_array[] = htmlspecialchars($employee_duty ['duty'], ENT_QUOTES, 'UTF-8');
}
echo implode(" / ", $duties_array); ?>
<?php endforeach; ?>