A family visa allows you to work. If you have a Red-White-Red Card Plus, you can work. However, depending on the sort of residency that your sponsor possesses, you will be given permission to work.
Keep in mind that you won’t be allowed to work if you’ve applied for a settlement permit that restricts your access to the job market.