Hey @Ankush Kumar
Welcome to Atlassian Community !!
In way jira groups are not directly associated with projects but groups are used in Permissions Schemes, Notification Schemes, User/Roles, Filters, Dashboards., Workflows, Custom Field like group picker, Global Permissions, etc..
So in way if you are able to get these info on where groups are used from above said things then you will get the projects too.
Check out this link from Atlassian official KB which says has SQL queries to get the group usage https://confluence.atlassian.com/jirakb/how-to-identify-group-usage-in-jira-441221524.html
Few more related threads:
Please find the Ref link for DB Commands here
You can audit the group's usage
Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events