原生MYSQL连接

<?php
define("HOST", "127.0.0.1");
define("USER", "root");
define("PWD", "root");
define("DATABASE", "distributio");

function mysqllink($pid){
	$con = mysqli_connect(HOST,USER,PWD,DATABASE);
	// var_dump($con);die;
	if (!$con){
	  die('Could not connect: ' . mysqli_error());
	}
	$pid = isset($_GET['pid']) ? $_GET['pid']:0; 

	$sql2 = "SELECT * FROM user where pid = {$pid}";
	$r_s = mysqli_query($con,$sql2);
	while($r_w = mysqli_fetch_assoc($r_s)){
		$sql3 = "SELECT * FROM user where pid = {$r_w['id']}";
		$sr_s = mysqli_query($con,$sql3);

		while ($r_ws = mysqli_fetch_assoc($sr_s)) {
			echo "ID为{$r_w['id']}的一级经销商下面的二级为".$r_ws["id"];
			echo "</br>";
			$sql4 = "SELECT * FROM user where pid = {$r_ws['id']}";
			$sr_a = mysqli_query($con,$sql4);
			while ($row = mysqli_fetch_assoc($sr_a)) {
				echo "ID为{$r_w['id']}的一级经销商下面的三级为".$row["id"];
				echo "</br>";
			}
		}
	 }
}