followers with following flag

$followers=DB::table('user_followers as f')->join('users as u', 'u.id', '=', 'f.follower_id')

            ->leftJoin('user_followers AS b', function($join){

                $join->on('b.follower_id', '=', 'f.leader_id')

                     ->on('b.leader_id', '=', 'u.id');

            })

            ->selectRaw(DB::raw("u.user_id,u.full_name,u.username,u.avatar,

            case when b.follower_id is null then 0

                when b.follower_id is not null and  b.status=1 then 1

            else 2

            end as isFollowing,

            case when b.follower_id is null then 'Follow'

                when b.follower_id is not null and  b.status=1 then 'Pending'

            else 'Following'

            end as isFollowing

            "))

            ->where("f.leader_id",$authUserId)

            ->paginate(5);

            ;

-----------------------------------------

Mysql

----------------------------------

 SELECT 

    u.id,

    u.username,

    f.status,

    case when b.follower_id is null then -- No record in b if 3 didn't follow this user back.

       'User is not following back'

    else

       'User is following back'

    end as back

FROM 

    user_followers f -- IDs of followers of user 3

    INNER JOIN users u  -- User information of those followers

       ON u.id = f.follower_id

    LEFT JOIN user_followers b  -- Check if 3 follows them back.

       ON b.follower_id = f.leader_id and

          b.leader_id = u.id

WHERE

    f.leader_id = 582