How to write a SQLite statement to recommend a user?

I'm working on a friends feature, where I would like to show the friends who are friends of my friends. in essence if user A and user B are friends, and user B and user C are friends, then how would i write an SQL statement to recommend user A to user C?

id | user | following
 1 |  A   |   B
 2 |  B   |   C

From this table, how would i write an SQL statement to recommend user A to user C?

Thanks in advance