Friends count of my friends

[eluser]rwestergren[/eluser]
Not sure what you mean by the original query. If you're trying to get the number of friends for all users:

Code:

function get_users()
{
    $query = $this->db->query("
    SELECT *,
            (SELECT COUNT(*) as friend_count
            FROM friends f
            INNER JOIN users u on(u.id = f.friend_id)
            WHERE f.user_id = $user_id AND f.approved = 1) AS f_count
    FROM users u1
    ");
    return $query;
}