$query = "SELECT useraccount.Username, tariff.Name as tariffs
FROM useraccount
INNER JOIN tariff ON useraccount.tariffs = tariff.id";

    $result = mysqli_query($conn,$query);
    if($result->num_rows){
        while($row = $result ->fetch_object()){
            echo "{$row->Username} ({$row->tariffs}) <br>";
        }
    }else{
        echo "No results";

    }


    $query2 = "SELECT";
    $result2 = mysqli_query($conn,$query2);

// Using a wildcard to get all useraccount data.
$query = "SELECT useraccount.*, tariff.Name as tariffs
FROM useraccount
INNER JOIN tariff ON useraccount.tariffs = tariff.id";

$result = mysqli_query($conn,$query);
if($result->num_rows){
    while($row = $result ->fetch_object()){
        // Reference any user data you want.
        echo "{$row->Username} {$row->EmailAddress} {$row->PostCode} ({$row->tariffs}) <br>";
    }
}

$servername = "localhost";
 $username = "username";
 $password = "password";
 $dbname = "myDB";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
 }

 $sql = "SELECT useraccount.Username, tariff.Name FROM useraccount INNER JOIN tariff ON useraccount.id = tariff.id";
 $result = $conn->query($sql);

 if ($result->num_rows > 0) {
      // output data of each row
     while($row = $result->fetch_assoc()) {
    echo "Username: " . $row["username"]. " - Tarrif: " . $row["name"]. "<br>";
}
} else {
    echo "0 results";
}
$conn->close();