Try the following query:

SELECT
C.cb_regnoyearofpassing,
C.cb_fathername,
C.cb_sdob,
C.cb_semisteryear,
C.cb_course,
C.cb_qualification,
C.cb_gender,
C.cb_category,
C.cb_totalfeeksou,
C.cb_branchname,
C.avatar,
C.user_id
FROM
#__comprofiler C INNER JOIN #__users U
ON C.user_id = U.id
INNER JOIN #__user_usergroup_map UM
ON U.id = UM.user_id
INNER JOIN #__usergroups UG
ON UM.group_id = UG.id
WHERE
U.block = 0
AND
UG.title = 'Registered'

Regards,
ARI Soft

Dear sir,
Thank you very very much for your help and support,
now it is working perfectly,
Thanking you
Madhusudhan krishnan