Prova così:
$mysql->query("SELECT friends.id AS `id`, friends.user AS `user`, friends.friend AS `friend` FROM `friends` LEFT JOIN `users` ON friends.friend = users.username WHERE friends.user='$my_user' ORDER BY `friends`");
Ciao!
PS
Non so se funzionerà! L'ho buttata lì!

Rispondi quotando