PHP - Ordenar por orden

function relationship_suggest($limit, $refId = null, $only_people = false) {

	$ignoredUsers = mostIgnoredUsers();

	$refId = ($refId) ? $refId : get_userid();

	$whereClause = "";

	$ignoredUsers = array_merge($ignoredUsers, get_friends($refId));

	$ignoredUsers = array_merge($ignoredUsers, get_requested_friends($refId));

	$friendsFriends = get_friends_of_friend($refId);

	if($friendsFriends) {

		$friendsFriends = implode(',', $friendsFriends);

		$whereClause .= "id IN({$friendsFriends}) ";

	}

	//$followersFollowing = get_following_following($refId);

	$ignoredUsers = array_merge($ignoredUsers, get_following($refId));

	$userCountry = get_user_data('country');

	$userCity = get_user_data('city');

	$userState = get_user_data('state');

	$whereClause .= ($whereClause) ? " OR `country`='{$userCountry}' OR `city`='{$userCity}' OR `state`='{$userState}' OR avatar !=''" : "`country`='{$userCountry}' OR `city`='{$userCity}' OR `state`='{$userState}' OR avatar !=''";

	$whereClause = fire_hook('users.suggestion.sql', $whereClause);

	$after_whereClause = "";

	$after_whereClause = fire_hook('users.category.filter', $after_whereClause, array($after_whereClause, true));

	$ignoredUsers = implode(',', array_merge(array($refId), $ignoredUsers));

	$fields = get_users_fields();

	$query = "SELECT {$fields} FROM `users` WHERE `id`NOT IN({$refId}) AND ({$whereClause}) AND id NOT IN ({$ignoredUsers}) AND activated=1 {$after_whereClause} ORDER BY rand()";

	$query = fire_hook("state.city.suggestions", $query, array($fields, $refId, $whereClause, $ignoredUsers));

	if($only_people) {

		$query = fire_hook('get.suggest.non.doctors', $query, array($fields, $refId, $whereClause, $ignoredUsers));

	}

	return paginate($query, $limit);

}

SELECT * FROM tabla ORDER BY followers DESC

<?php $filter = array('feature' => 'featured'); $page = 1; $featured_members = people_get_users($filter, $limit); ?>

<?php if(count($featured_members->results()) > 0): ?>

	<div class="people box people box users-box">

		<div class="title"><?php echo lang('featured-members') ?>

			<a ajax="true" href="<?php echo url_to_pager('people') ?>?feature=featured" class="more-link pull-right"><i class="ion-ios-arrow-forward"></i></a>

		</div>

		<div class="clearfix">

			<?php foreach($featured_members->results() as $user): ?>

				<?php $gender = (isset($user['gender']) and $user['gender']) ? $user['gender'] : null ?>

				<?php $gender_image = ($gender) ? img("images/avatar/{$gender}.png") : img("images/avatar.png") ?>

				<?php $user_image = $user['avatar'] ? url_img($user['avatar'], 200) : $gender_image ?>

				<a href="<?php echo url($user['username']) ?>" ajax="true" class="user" style="background-image: url(<?php echo $user_image ?>)">

					<h6 class="name"><?php echo get_user_name($user) ?></h6>

				</a>

			<?php endforeach ?>

		</div>

	</div>

<?php endif ?>

<?php if(is_loggedIn()): ?>

	<?php load_functions("relationship::relationship");

	$users = relationship_suggest($limit, null, true); ?>

	<?php if($users->total): ?>

		<div class="box users-box" id="people-suggestion-box">

			<div class="title">

				<?php echo lang('relationship::people-suggestion') ?>

				<a ajax="true" href="<?php echo url_to_pager('suggestions') ?>"><i class="ion-ios-arrow-forward pull-right"></i></a>

			</div>

				<div class="clearfix slider-side-widget">

				<?php foreach($users->results() as $user): ?>

					<a style="background-image: url(<?php echo get_avatar(200, $user) ?>)" class="user" ajax="true" href="<?php echo profile_url(null, $user) ?>">

					    <h6 class="name"><?php echo get_user_name($user) ?> <?php echo verify_badge($user) ?></h6>

					</a>

				<?php endforeach ?>

			</div>

		</div>

	<?php endif ?>

<?php endif ?>