Join в помощь,ёпт
Добавлено 07.06.15 в 17:03:35:
<?php
$query=mysql_query("SELECT `clan_member`.* ,`users`.* FROM `clan_member` LEFT JOIN `users` ON `clan_member`.`user` = `users`.`id` AND `clan_member`.`clan` != '".$i['id']."' ORDER BY `clan_member`.`rank` DESC,`clan_member`.`exp` DESC LIMIT ".$start.", ".$max.""

;
while($row_user = mysql_fetch_array($query)){
//Выводишь шлёпанца
}
?>