涉及会话和数组的mysql查询

I am stuck on a query. A supervisor(id of 7 lets say) posts a job to the jobs table. when he posts it, he sets a group level of 0-4 for that posting...all that is held in the jobs table. now i want to display those on a page

if the job relevant_group is set at 0, anyone is allowed to see it. if the job relevant_group is not set at 0, then we need to grab the viewers session employee_id and use that to see if they are in one of the groups for that supervisor

so if the employee is logged in and his id is in one of the group arrays for that supervisor...then i want to display that job listing the employee could be in other groups with other supervisors, but i only want to show the job if they are in a group posted by the job_lister_id the job_lister_id in jobs table and supervisor_id in employees table would be the relevant matching fields

jobs table

job_listing (text I want displayed in this field)

job_lister_id (int same as supervisor_id in table below)

relevant_group ( enum 0,1,2,3,4 )



employees table

supervisor_id  (int same as job_lister_id in table above)

group1_members (comma seperated id's of employees in this group..7,9,87)

group2_members (comma seperated)

group3_members (comma seperated)

group4_members (comma seperated)