Get all reporting head details just pass id only

SELECT

 a.id as exe_id,

    a.sap_code as exe_sapcode,

    a.username as exe_username,

    b.user_fname as exe_user_fname,

    b.user_mobile as exe_mobile,

    (CASE WHEN b.vertical = '0' THEN 'Used Car' WHEN b.vertical = '1' THEN 'Tractor' WHEN b.vertical = '2' THEN 'New Car' WHEN b.vertical = '3' THEN 'Mahindra New Car' WHEN b.vertical = '4' THEN '' WHEN b.vertical = '5' THEN 'DMT' WHEN b.vertical = '6' THEN '3W' WHEN b.vertical = '7' THEN 'CV' WHEN b.vertical = '9' THEN 'Manthan'

    END) AS 'exe_vertical',

    ( CASE

          WHEN a.user_status = '1' THEN 'Active'

          WHEN a.user_status = '2' THEN 'Inactive'

          WHEN a.user_status = '3' THEN 'Inactive'

    END ) AS 'exe_current_status',

    e2.id as abm_id,

    e2.sap_code as abm_sap_code,

    e2.username as abm_username,

    b1.user_fname as abm_user_fname,

    b1.user_mobile as abm_mobile,

    (CASE WHEN b1.vertical = '0' THEN 'Used Car' WHEN b1.vertical = '1' THEN 'Tractor' WHEN b1.vertical = '2' THEN 'New Car' WHEN b1.vertical = '3' THEN 'Mahindra New Car' WHEN b1.vertical = '4' THEN '' WHEN b1.vertical = '5' THEN 'DMT' WHEN b1.vertical = '6' THEN '3W' WHEN b1.vertical = '7' THEN 'CV' WHEN b1.vertical = '9' THEN 'Manthan'

    END) AS 'abm_vertical',

    ( CASE

          WHEN e2.user_status = '1' THEN 'Active'

          WHEN e2.user_status = '2' THEN 'Inactive'

          WHEN e2.user_status = '3' THEN 'Inactive'

    END ) AS 'abm_current_status',

    e3.id as dm_id,

    e3.sap_code as dm_sap_code,

    e3.username as dm_username,

    b2.user_fname as dm_user_fname,

    b2.user_mobile as dm_mobile,

    (CASE WHEN b2.vertical = '0' THEN 'Used Car' WHEN b2.vertical = '1' THEN 'Tractor' WHEN b2.vertical = '2' THEN 'New Car' WHEN b2.vertical = '3' THEN 'Mahindra New Car' WHEN b2.vertical = '4' THEN '' WHEN b2.vertical = '5' THEN 'DMT' WHEN b2.vertical = '6' THEN '3W' WHEN b2.vertical = '7' THEN 'CV' WHEN b2.vertical = '9' THEN 'Manthan'

    END) AS 'dm_vertical',

    ( CASE

          WHEN e3.user_status = '1' THEN 'Active'

          WHEN e3.user_status = '2' THEN 'Inactive'

          WHEN e3.user_status = '3' THEN 'Inactive'

    END ) AS 'dm_current_status',

    e4.id as ch_id,

    e4.sap_code as ch_sapcode,

    e4.username as ch_username,

    b3.user_fname as ch_user_fname,

    b3.user_mobile as ch_mobile,

    (CASE WHEN b3.vertical = '0' THEN 'Used Car' WHEN b3.vertical = '1' THEN 'Tractor' WHEN b3.vertical = '2' THEN 'New Car' WHEN b3.vertical = '3' THEN 'Mahindra New Car' WHEN b3.vertical = '4' THEN '' WHEN b3.vertical = '5' THEN 'DMT' WHEN b3.vertical = '6' THEN '3W' WHEN b3.vertical = '7' THEN 'CV' WHEN b3.vertical = '9' THEN 'Manthan'

    END) AS 'ch_vertical',

    ( CASE

          WHEN e4.user_status = '1' THEN 'Active'

          WHEN e4.user_status = '2' THEN 'Inactive'

          WHEN e4.user_status = '3' THEN 'Inactive'

    END ) AS 'ch_current_status'

FROM

    user_login a

        LEFT JOIN

    user_info b ON b.uid = a.id

        LEFT JOIN

    user_login e2 ON e2.id = a.reporting_head

    LEFT JOIN

    user_info b1 ON b1.uid = e2.id

        LEFT JOIN

    user_login e3 ON e3.id = e2.reporting_head

    LEFT JOIN

    user_info b2 ON b2.uid = e3.id

        LEFT JOIN

    user_login e4 ON e4.id = e3.reporting_head

    LEFT JOIN

    user_info b3 ON b3.uid = e4.id

WHERE

    a.user_type = '3' AND b.vertical='0'

************************************************************************

SELECT

 a.id as exe_id,

    a.sap_code as exe_sapcode,

    a.username as exe_username,

    b.user_fname as exe_user_fname,

    b.user_mobile as exe_mobile,

    ( CASE

          WHEN a.user_status = '1' THEN 'Active'

          WHEN a.user_status = '2' THEN 'Inactive'

          WHEN a.user_status = '3' THEN 'Inactive'

    END ) AS 'exe_current_status',

    e2.id as abm_id,

    e2.sap_code as abm_sap_code,

    e2.username as abm_username,

    b1.user_fname as abm_user_fname,

    b1.user_mobile as abm_mobile,

    ( CASE

          WHEN e2.user_status = '1' THEN 'Active'

          WHEN e2.user_status = '2' THEN 'Inactive'

          WHEN e2.user_status = '3' THEN 'Inactive'

    END ) AS 'abm_current_status',

    e3.id as dm_id,

    e3.sap_code as dm_sap_code,

    e3.username as dm_username,

    b2.user_fname as dm_user_fname,

    b2.user_mobile as dm_mobile,

    ( CASE

          WHEN e3.user_status = '1' THEN 'Active'

          WHEN e3.user_status = '2' THEN 'Inactive'

          WHEN e3.user_status = '3' THEN 'Inactive'

    END ) AS 'dm_current_status',

    e4.id as ch_id,

    e4.sap_code as ch_sapcode,

    e4.username as ch_username,

    b3.user_fname as ch_user_fname,

    b3.user_mobile as ch_mobile,

    ( CASE

          WHEN e4.user_status = '1' THEN 'Active'

          WHEN e4.user_status = '2' THEN 'Inactive'

          WHEN e4.user_status = '3' THEN 'Inactive'

    END ) AS 'ch_current_status'

FROM

    user_login a

        LEFT JOIN

    user_info b ON b.uid = a.id

        LEFT JOIN

    user_login e2 ON e2.id = a.reporting_head

    LEFT JOIN

    user_info b1 ON b1.uid = e2.id

        LEFT JOIN

    user_login e3 ON e3.id = e2.reporting_head

    LEFT JOIN

    user_info b2 ON b2.uid = e3.id

        LEFT JOIN

    user_login e4 ON e4.id = e3.reporting_head

    LEFT JOIN

    user_info b3 ON b3.uid = e4.id

WHERE

    a.user_type = '3' AND b.vertical='3'

**************************************

                                                                OR



SELECT
    a.id as exe_id,
    a.sap_code as exe_sapcode,
    a.username as exe_username,
    b.user_fname as exe_user_fname,
    b.user_mobile as exe_mobile,
    b.vertical as exe_vertical,
    e2.id as abm_id,
    e2.sap_code as abm_sap_code,
    e2.username as abm_username,
    b1.user_fname as abm_user_fname,
    b1.user_mobile as abm_mobile,
    e3.id as dm_id,
    e3.sap_code as dm_sap_code,
    e3.username as dm_username,
    b2.user_fname as dm_user_fname,
    b2.user_mobile as dm_mobile,
    e4.id as ch_id,
    e4.sap_code as ch_sapcode,
    e4.username as ch_username,
    b3.user_fname as ch_user_fname,
    b3.user_mobile as ch_mobile
FROM
    user_login a
        LEFT JOIN
    user_info b ON b.uid = a.id
        LEFT JOIN
    user_login e2 ON e2.id = a.reporting_head 
    LEFT JOIN
    user_info b1 ON b1.uid = e2.id
        LEFT JOIN
    user_login e3 ON e3.id = e2.reporting_head
    LEFT JOIN
    user_info b2 ON b2.uid = e3.id
        LEFT JOIN
    user_login e4 ON e4.id = e3.reporting_head
    LEFT JOIN
    user_info b3 ON b3.uid = e4.id
WHERE
    a.user_type = '3' AND a.id = '55'

**************************************************************

Get Specific user type reporting head details:

    SELECT a.id,a.username,b.user_fname,b.user_mobile,( CASE

              WHEN a.user_status = '1' THEN 'Active'

              WHEN a.user_status = '2' THEN 'Inactive'

              WHEN a.user_status = '3' THEN 'Inactive'

              END ) AS 'status', c.id AS 'reporting_head_id',c.username AS 'reporting_head_username',d.user_fname AS 'reporting_head_fname',d.user_mobile AS 'reporting_head_mobile',( CASE

              WHEN c.user_status = '1' THEN 'Active'

              WHEN c.user_status = '2' THEN 'Inactive'

              WHEN c.user_status = '3' THEN 'Inactive'

              END ) AS 'reporting_head_status' FROM `user_login` `a` 

              LEFT JOIN `user_info` `b` ON `a`.`id`=`b`.`uid`

              LEFT JOIN `user_login` `c` ON `c`.`id`=`a`.`reporting_head`

              LEFT JOIN `user_info` `d` ON `d`.`uid`=`c`.`id`

              WHERE a.user_type = '5' AND b.vertical='6' ORDER BY a.user_status ASC