query("SELECT u.username,
CASE
WHEN ub.badge_id IS NOT NULL THEN ub.badge_id
WHEN r.badge_id IS NOT NULL THEN r.badge_id
ELSE NULL
END AS badge_id
FROM users u
LEFT JOIN user_badges ub ON ub.user_id = u.id
LEFT JOIN role_assigns ra ON ra.user_id = u.id
LEFT JOIN roles r ON r.id = ra.role_id
ORDER BY RAND() LIMIT 3
");
while ($row = $stmt->fetch()) {
echo '
';
if ($row["badge_id"]) {
echo '
';
}
echo '
';
echo $row["username"];
echo ': ';
echo '
![]()
';
echo '
';
}
?>