Есть скрипт

$site_sql = q($link, "SELECT `id`, `url`, `ref_url` FROM `". BD_PR ."sites`");
			
	while($site_bd = mysqli_fetch_assoc($site_sql))
	{
		$site_id_sql = q($link, "SELECT * 
								 FROM `". BD_PR ."ref_usr` 
								 WHERE `id_site` = '". $site_bd['id'] ."' AND 
									   `id_user` = '". $user_bd['id'] ."'");

		if (mysqli_num_rows($site_id_sql))
		{
			$site_id_bd = mysqli_fetch_assoc($site_id_sql);
			
			$link_klick = $site_id_bd['klick'];
			$link_user  = htmlspecialchars($site_id_bd['user']);
		}
		else
		{
			$link_klick = 0;
			$link_user  = null;
		}

		$link_url = preg_split("/[\s*]+/", $site_bd['ref_url']);
		
		echo '<tr>
				<td>'. htmlspecialchars($site_bd['url']) .' ('. $link_klick .')</td>
				<td>'. $link_url[0] . $link_user . $link_url[1] .'</td>
			  </tr>';
	}

Как его переделать с функцией mysqli_prepare?