the table you mentioned i only see one id reflecting till the end of the table andi can't see any rules in there

The rule is under the rule column. For example the first row says "User 849 has the Profile Tab 7 set to Public (0)".

i see you mention i need to use API , but how do i do that if i want to check the privacy preference of users for their Profile pic?

You'd use getFields API or substitute in the HTML value of the avatar field. If privacy is blocking the field it'll return/output nothing.

getFields API:
www.joomlapolis.com/support/tutorials/120-api-usage/18361-obtaining-field-values-through-getfields-api

Substitution:
[cb:userfield field="avatar" /]

Both usages will work in a code action or code field.

in my privacy table there is only one user showing , not sure why ?

There's 1 row per privacy protection. So if you've 20 tabs protected that's 20 rows per user. You likely have multiple pages in phpmyadmin and it'll only show so many entries per page.

I have a .php file saved in a folder in www directlry from where this code is running,

1) which folder should I put this file in to get access to CB API ?
2)i will point this file to cron once this completes, doing this through a fieldd how would i run this query and email users ?

Then you can't use the API. Your code needs to be executed from within Joomla/CB to have access to APIs. Use a Code action in CB Auto Actions or a Code field depending on your needs. Since you need emails and other processing then using a Code action in CB Auto Actions would be best. Set triggers to None then you can manually execute the action via it's URL under the Global tab of the action.

You can't establish a user object because you've zero access to Joomla or CB APIs. You're executing a file entirely outside of Joomla and CB scope. Why do you need it to be a file when you can put your code directly in the Code action. You could also do an include in a Code action and should then be able to use APIs.