hptesttable

<?php

$id = intval($_GET['id']);
$host = "localhost";
$db = "your_db";
$charset = "utf8";
$user = "db_user";
$pass = "db_pass";

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$opt = array(
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
);

$pdo = new PDO($dsn, $user, $pass, $opt);

$stmt = $pdo->prepare('SELECT * FROM users WHERE id = ?');
$stmt->execute([$id]);
while ($item = $stmt->fetch(PDO::FETCH_LAZY))
{
    echo '<tr>';
    echo '<td><a href="?im_id=' . $id . '&id=' . $item['id'] . '">' . $item['user_name'] . '</a></td>';
    echo '<td>' . $item['adress'] . '</td>';

    $stmt = $pdo->prepare('SELECT * FROM test WHERE user_id = ?');
    $stmt->execute([$item['id']]);
    while ($row = $stmt->fetch(PDO::FETCH_LAZY))
    {
        echo "<td>{$row[0]}</td>";
    }
}
?>