On our Magic cruise last week, we sat with the Captain at Lumieres.
OK- we actually sat at the table next to him! He was sitting with just his wife at the table next to our regular table and our server team was serving them.
Our server jokingly told him that they could switch the tables if he wanted to sit with our children. He said no, but also said that we were doing a very good job raising our children as they were very well behaved. ( Two couples with four kids- 9 and 3 year old boys, and 7 and 5 year old girls.)
That was formal night, and we also had our picture taken with him earlier in the evening.
PS- Edited to add: Also if you take the regular bridge tour (not the VIP one that only certain people get invited to) it is done by a member of the Adult Programming Staff and not any of the ship's officers- just FYI.