Mysql table structure
A suitable solution is to create third table to link users with clients and so give access:

users             lnk_user_client_access                
-----             ----------------------                clients   
id_user --------- id_user                              --------
...               id_client   ------------------------ id_client
                                                       ...