You should have a User table, with a user ID and all the user details, then perhaps column with a comma separated list of friends user ID's, then use PHP's explode() function to create an array of friends user IDs. You could then have a foreach loop go through the array, and grab info on the friend from the User table.
foreach($friendIDs as $friendID)
$friendInfoResult = mysql_query("
SELECT * FROM
`ID` = '" . $friendID . "'
$friendInfo = mysql_fetch_assoc($friendInfoResult);
// Then loop get all the other fields from friendInfo["thefield"]
Note: There's probably a far more elegant solution in SQL itself, so good luck.