使用按钮从数据库中删除用户记录

我正在创建一个管理网站，所有用户都在上面。我想在每个用户行上做一个删除按钮，所以当我单击该按钮时，该用户将从数据库中删除。

<?php
    $hey = $mysqli->prepare("SELECT id, username, email, rr, house, date, bil, rank FROM user");
    $hey->execute();
    $hey ->bind_result($id, $username, $email, $rr, $house, $date, $bil, $rank);
    echo 
        "<table cellpadding='5' cellspacing='5' style='background-color: white; margin-left: -4px;' border='1'>
        <tr>
        <th>ID</th>
        <th>BRUGERNAVN</th>
        <th>EMAIL</th>
        <th>PENGE</th>
        <th>HUS</th>
        <th>RANK</th>
        <th>BIL</th>
        <th>DATO</th>
        <th>Indstillinger</th>
        </tr>";
        while( $hey->fetch() ){
            echo "<tr>";
            echo "<td>" . $id ."</td> ". "<td>" .$username ."</td> ". "<td>" .$email ."</td> ". "<td>" .$rr ."</td>". "<td>". $house . "</td>". "<td>". $rank . "</td>". "<td>". $bil . "</td>". "<td>". $date . "</td>". "<td> <center>DELETE</center> </td>";
            echo "</tr>";
        }
        echo "</table>";
    $hey->close();
?>