How to display two or more array on same table

See more:

PHP

MySQL

Hey guys I have one mysql table where i have some info like user id now to display that data I need to retrieve from user table name of the user based on that id

Table tickets

<?php 


$mysql5 = mysqli_query($dbc, "SELECT * FROM tickets where status='1' ORDER BY dt DESC LIMIT 6 ");
if($indtbl = mysqli_fetch_array($mysql5))
{

  $title = $indtbl['tickettitle']; 
  $company = $indtbl['companyname'];   
  $companyid =$indtbl['compid'];  
  $trackid = $indtbl['trackid']; 
  $assignto = $indtbl['assignto'];  
  $priority = $indtbl['priority']; 
  

}
?> 

table users

<?php
$findresults2323 = mysqli_query($dbc, "SELECT * FROM users WHERE id= '$assignto'");
if($rest = mysqli_fetch_array($findresults2323))
{

  $userimg = $rest['img']; 
  $fname1 = $rest['fname'];   
  $lname1 = $rest['lname'];  

}
?>

What I have tried:

now I am trying to fetch that two array in table here is my code

 <table class="table table-hoverable">
                      <thead>
                        <tr>
                          <th class="text-left">Title</th>
                          <th>Company</th>
                          <th>Ticket ID</th>
                          <th>Assign To</th>
                          <th>Priority</th>
                          
                        </tr>
                      </thead>
                      <?php

while($rowten = mysqli_fetch_array($mysql5)) {


$retrive11 = mysqli_fetch_array($findresults2323);

?>
<tr>
    <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["tickettitle"]; ?></td>
    <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["companyname"];?> <?php echo $rowten["compid"];?></td>
    <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["trackid"]; ?></td>
    <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $retrive11['fname'];?></td>
    <td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $rowten["priority"]; ?></td>
</tr>
<?php

}


?>
                    </table>

and he is retrieving first array but for second one i have this issue

Notice: Trying to access array offset on value of type null in C:\xampp\htdocs\Ticketing\demo\index.php on line 459

and this is the line 459

<td><a href="readit.php?id=<?php echo $rowten["id"];?>"><?php echo $retrive11['fname'];?></td>