Chat Notification using laravel

<?php 

foreach ($msgs as $key => $msg) {

$sender_id = $msg->sender_id;
$usernameData = DB::table('users')->where('id', $sender_id)->get();
$OrderData = DB::table('service_checkout')->where('user_id', auth()->user()->id)->get();
$usernameDataCount = DB::table('chat_open')->where('reciver_id', auth()->user()->id)->count();

    foreach ($usernameData as $key => $usrData) {
      foreach ($OrderData as $od) {
        $order_id = $od->order_id;
?>

<li class="mb-2">
<a class="dropdown-item border-radius-md" href="/project/chat/{{$order_id}}/{{$sender_id}}" target="_blank">
<div class="d-flex align-items-center py-1">
<span class="material-icons">email</span>

<div class="ms-2">
<h6 class="text-sm font-weight-normal my-auto">
{{$usernameDataCount}} Messages by {{$usrData->name}}
</h6>

</div>
</div>
</a>

</li>

<?php } } } ?>

</ul>
</li>