I have two table role and user I want to join both table

I have two tables rolea and users. Roles table id map in users table.

I want join these table and i have required array like array( array( id=>1,rolename=>admin, usersdata=> array( id=>1, roleid=>1,username=>amit

) array( id=>1, roleid=>1,username=>amit

)

)

)

Like this in array role data and in subarray role wise user data

via Chebli Mohamed