Do you recommend going gym and doing different workouts including weights, while having sciatica?

it depends. If your sciatica is caused by instability in the spine, it is best to avoid heavy lifting, that may worsen the problem.
Yes. Gym is good for you, as long as the exercises don't hurt. See pain/spine specialist to get pain relief and you might find exercising may even be better.