How do I get friend list from Friends table with counts of friends of my friends

php mysql node.js

PHP Snippet 1:

select user_id, count(*) cnt 
   from  Friends 
   where user_id in  
      (select friend_user_id 
         from Friends 
         where user_id = user_id_of_A)
   group by user_id