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ì!