Ok, hey I have:

Users table:

UserID, Rank, and other user details


UserID, and other details.

I have this statement:
$query = "SELECT * FROM `platoon_members` WHERE `platoon_id` = '{$row[id]}' ORDER BY `rank` ASC ;";
But I need to ORDER BY the rank feild in the users table.
There is no Rank Field in the platoon_members table.

if you dont understand me, ill explain in more detail