$db->bind("uname",$uname);
$query = $db->query("SELECT uname FROM [table] WHERE users = :uname");
if (!isset($query[0]['users'])) { //therefore username is unique
    //insert user to database
} else {
    //prompt 'user already exists'
}