I want users list data with flag value for group users and group users not in

I have one query.

I have users table, groups table data and users_group table.

How i want get all users list data for particular group id is 2 with flag value 0 for not in group and flag value 1 for group to assign new variable using PHP and MySQL sample example or query?

via Chebli Mohamed